Forum Discussion
List view threshold limit in site libraries or lists in SharePoint Online
Will or is the list view threshold of 5000 objects in SharePoint Online gone? When loolking around in different forums and blogs it seems that this only applies to SharePoint 2016 on-premises for now.
7 Replies
So list views returning more than 5,000 items woudl break, but Search shouldn't. Here's an example of some reporting that I'm doing.
StatePayroll list with 33,497 items in it that I'm rolling up the data using the Search REST API and displaying using Google Charts.Here's the blog post where I talk about how I did it:
https://jaredmatfess.wordpress.com/2016/12/04/creating-google-charts-with-the-sharepoint-search-api/
So point being, if search is breaking on lists with over 5,000 items (and not list views) you might have a bigger problem on your hands.
Hi Johan ÅSLUND,
I don't think that this threshold has disappeared. Where did you find this?
SharePoint Online software boundaries and limits - Office Support
List view threshold limit in site libraries or lists
5000 max items per view (without index) and 12 lookup columns per view. For more information, see Manage large lists and libraries in Office 365.
5000 max items per view (without index) and 12 lookup columns per view. For more information, see Manage large lists and libraries in Office 365.
Source:
- Pieter is correct, the limit is still there and what Microsoft has done for SPO and SP 2016 is just introduce indexing improvements to relax this current limit...in regards of what will happen in the future? There is nothing public that can be shared now
