Forum Discussion
Lists: Threshold error with filtered view (<5000 items)
Hi,
I have a SPO List with ~40000 entries. To work with it I created a view which gives me less than 100 entries at a time. I can set a filter on a field called "localID" and also modifying the URL to have a different localID works for me (owner of the SPO site).
However, other owner of the site are NOT able to use the list nor the filtered view. They get the famous threshold error.
The permissions are not changed and are still the same as on the site level.
Anyone else encountered this behaviour and how did you overcome it?
Best regards
1 Reply
FabvE Thanks for bringing this up. I’ve noticed that while I can access filtered views using the localID, others are hitting the list view threshold error. This is likely due to how SharePoint handles large lists and indexing.
To resolve this, we should ensure that the localID field is indexed. SharePoint uses indexed columns to efficiently filter large lists. I’ll check the list settings and confirm if localID is indexed. If not, I’ll add the index and reconfigure the view accordingly.
Also, make sure that the view is using filters that reduce the result set below 5000 items and that the filters are applied to indexed columns. This should help everyone access the list without errors.
