Contents
There is a wrong perception about the SharePoint list view threshold 5000 error – many users think that the SharePoint list/library just can store 5000 items but that is not true, in fact, SharePoint list can store 30 million items. Then why are we getting this error?
I am trying to query a SharePoint list which has more than 5000 items. When I run filter query with ID, it returns the expected results. But when I run the same query with any other column it throws an error as shown below. I know that there is a threshold limit of 5000.
Can you sort a 5000 item list in SharePoint?
You’re correct, you can’t sort a list with more than 5000 items on a non-indexed column, your views that use that sort will not work. You can try indexing those columns and that should fix your views.
Is there a 5000 list view threshold in SharePoint?
When a normal user accesses a SharePoint list which has more than 5000 items, that user will get a 5000 listview threshold error mentioned above and list will not be opened with the data but the same list will be loaded with the data if it accessed by an administrator as it has higher limit i.e. 20000.
Try to split the data in multiple list or library. Create multiple views and add “AND” condition in the list filter criteria, never add “OR” condition, “OR” condition will try to get all data. Create index column – we can only have 20 indexed columns in a given list, so we need to plan this thoughtfully!
Item limit threshold isn’t actually about the storage capabilities. The issue is in displaying the vast amount of information. Microsoft introduced the 5,000 view limit on the document library with SharePoint 2010 for one purpose — to maintain the performance of the document library and its servers.