Forum Discussion
List view threshold limit in site libraries or lists in SharePoint Online
That would be fantastic news. I have a client every month who goes over 5000 and stops the search on the list working. It really is a piddlingly low number. If Microsoft get rid of it you'll hear my cheer from 100 miles away.
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.
- AnonymousMar 13, 2017
I 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.