Forum Discussion
Johan ÅSLUND
Nov 24, 2016Copper Contributor
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...
JaredMatfess
Mar 11, 2017Iron Contributor
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.
Anonymous
Mar 13, 2017I have not seen this problems Jared. I think it has to do with the count of columns and which columns are indexed Search is not the issue.
- JaredMatfessMar 13, 2017Iron ContributorSort of - you can return up to 5,000 items in a view. If your list is greater than 5,000 items the column you are filtering with needs to be indexed otherwise the view is throttled. Search can retrieve millions of items in a list (my example is showing 30,000 items with a call) above. The gentlemen above me (Andy) was mentioning Search breaking when a list goes over 5,000 items which should not be the case. The limitation for what the search index can hold is far greater than 5,000 items in a list.