'SharePoint view with 2900 records throwing 5000 limit error

I have a list that resides on SharePoint 2013 and we manage the records in The list using MS Access 2016. Basic add, remove, update to match stuff to an excel file we are provided twice per month.

I am running into the 5000 record error on list views with active filters that only have say 2900 records meeting the criteria.

If I query for the same filters in access I get the 2900 and the list only has 5200 total records.

I am looking for any direction of things to look for or articles to read that may help point me in the right direction of what may be causing this.

Thank you very n advance for any assistance you can provide.

vbams-accesssharepointlinked-list


Solution 1:[1]

What i have experienced with this is that if you have multiple conditions in your filter, and one of them returns over 4999 items you will get that error. What i have done in my case is to add conditions to my filter that use indexed columns to help initially limit the number of items result based on the indexed column.

For example, in my scenario, I had a filter that was based on the workflow status and the current user. But my filter initially did not use an indexed column and the condition "Status eq 'Approved'" returned over 5000 items.

https://tenant.sharepoint.com/sites/dev/_api/web/lists/getByTitle('Approvals')/items?$filter=Status eq 'Completed' and Author/EMail eq '[email protected]'

Changing the query to use the indexed AuthorId column, resolved my issue.

https://tenant.sharepoint.com/sites/dev/_api/web/lists/getByTitle('Approvals')/items?$filter=AuthorId eq 1234 and Status eq 'Completed'

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 ayodele

Related Questions