Joel's SharePoint Architecture Blog

SharePoint Server, SharePoint Online and Office 365 Training, Architecture, Administration and Development

SharePoint Thing a Day – 015 – Information Architecture. Dealing with Really Big Lists.

by

Dealing with Really Big Lists

View this post on Instagram

#spthingaday 015 – Information Architecture. Dealing with Really Big Lists. #SharePoint, #Office365.. 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://1jj.uk/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. #microsoft #microsoftoffice #microsoftsharepoint #microsofttraining #officetraining #freetraining #trainingvideos #contentmanagement #enterprisecontentmanagement

A post shared by JFDI Consulting #spthingaday (@jfdiconsulting) on

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.