Forum Discussion
List View >5000
Hi all.
I'm working with SharePoint with a list of greater than 5000 items and growing by the day. I'm in Classic View and I've created a view specifically for current 6 months but I'm unable to view my items.
The columns to be used as filters are:
1. 6_Month_Start (Indexed)
2. 6_Month_End (Indexed)
3. Department (Indexed)
The rules for the view are:
6_Month_Start is less than or equal to [Today]
AND
6_Month_End is greater than or equal to [Today]
AND
Department is equal to GA
So, the question / issue is this. Everything is indexed and the return of items should only be 279. Why am I receiving that my list view surpasses the threshold?
Side note: only Department of GA has more than 5000 entries in total but it shouldn't affect the view, right?
3 Replies
I am facing the same issue.
While the returned results from the filters is definitely under 5,000, all the views I had just show the exceed 5000 threshold error.
If I switch to the modern experience, the list can then be rendered with no issue. However, I would need it to work on the classic experience as well.
All columns used as filter are indexed. No sort by, group by, or total. The views used to work fine even when the total list items exceeded 5,000. However, from a point of time, the views all show the 5000 error message, which is unexpected.
Appreciate for any help on this.
Cheers
- So is the list not rendering at all, or are you worried about the error that shows on the list settings? You will always get the error on the list settings page, the question will be if you can view your data or not when using the view.
Trim your view down to show minimal columns, and start from there, make sure nothing is sorted that can't be indexed or filtered etc.- The list isn't rendering at all. I've reduced it down to 1 column (indexed) to see if it has any affect but I'm still unable to get the proper view shown.
