Forum Discussion
SharePoint Online: Rest API not working with people filter for list with more than 5000 items
Hi Folks, I'm trying to use SharePoint rest API to get items from a SPO list. It has around 15K items. But I'm using filters and expecting less than 30 items in the result. It works fine when nor...
Thank you for the suggestion. The people picker column is already indexed. Could you please let me know if this actually worked for you for lists with more than 5K items. I have received this suggestion before to index the column, just want to know if this worked for anyone.
Thank you.
I have just added a new discussion reporting a similar issue with the Title column when there is more than 5000 items in the library. The first filter returns around 100 items, but adding a filter by the Title shows nothing. I suspect it's related - despite the initial filter returning only 100 items, the second filter is working against ALL the items.