Hi @sns ,
If you are retrieving more than 5000 items or files at once in a single view, you will see an error message due to performance settings when retrieving items from large SharePoint lists.
You could try the following:
- You can use the modern experience of lists. Pagination works differently compared to the classic experience. As you continue to scroll in the view it will load the items.
- If the data in the list is larger then try to split the data into multiple lists.
- Create multiple list views or add filters to views.
- Add an index to the list column, and SharePoint automatically plays some role in the SQL server, allowing it to quickly analyze and return values that bypass the threshold. Or enable automatic index management in a list or document library, if set to daily it will automatically create an index when the list item exceeds 2500.
All in all, the above methods are all designed to return results with less than 5000 items after a particular view of the list has been retrieved.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.