Dealing with Really Big Lists
SharePoint Thing a Day – Lesson fifteen – Dealing with Really Big Lists.
So, you’ve broken clean through the 5000 limit, you’ve added all the indices you can, and you still find your list and library views fail to display.
You *did* use Site Columns, didn’t you? If not, go back to SharePoint Thing a Day – Lesson 005. :) (http://bit.ly/spthing005)
If you *did* build your list with Site Columns (and preferably also with Content Types), the Search Service in SharePoint and SharePoint Online creates Implicit Managed Properties for you. (http://bit.ly/2yKiZEh)
When SharePoint’s Crawler finishes processing the content it finds, you can search for items in the list or library and filter by the Managed Properties.
You can use the Classic view in SharePoint to put the Search Results Web Part on a page and run a search query for items in your List or Library.
If you want to maintain a List-like experience for your users, you can instead use the Content Search Web Part with a Custom Display Template to make it look familiar. (http://bit.ly/2zguoPp)
We don’t quite yet have these super powers in SharePoint Online Modern Search. If you want to leverage Search to interact with big lists on a Modern page, right now you need a developer.