<img height="1" width="1" src="https://www.facebook.com/tr?id=730305433807073&amp;ev=PageView &amp;noscript=1">
Start
Book a Demo

Advent Calendar Door 2: List navigation and data filtering: fighting the SharePoint’s 5000 list items limit.

avatar

Posted by Adis Jugo - 02 December, 2017

List navigation and data filtering: fighting the SharePoint’s 5000 list items limit

Everyone who was working with long SharePoint lists, knows the about List View Threshold limit of 5000 items. There are best practices with field indexing how to deal the best with that limit, but still, this all remains a big challenge: data navigation (filtering, drill down) is very difficult to achieve, and it can easily happen that the user doesn't find and doesn't see her data.

This is where skybow List View Search, an integral component of skybow Solution Studio, but also available as a separate SharePoint addin - comes to the rescue. It is by default added to the default list view of the master list in skybow Solution Studio, and it can be added manually from the toolbox on the right side of the screen to each view, or through the "Add an app" menu if SharePoint AddIn is used. In todays skybow Advent Calendar, I will show you how to configure this within minutes.

When you add the list view search, by default only the Title field is included. By clicking on the "Add icon", you can easily add as many fields as you need.

List view search options.png

Clicking on the “Filter” icon, you can also fine-tune all the filters – here, I am changing filtering operation of the Title field from “Begins with” (default operation) to “Contains”, to be able to search any part of the title field.

query editor skybow list view search

Clicking on the settings icon, you can decide if your users need to press the “Search” button for filtering to take place (recommended for *very* long lists), or if autofilter should be applied, and filtering happens as user types the values.

list view search settings.png

Please note, in order for this to work with long lists, you will still need to set up filed indexing in a proper way, as described in Microsoft’s best practices.
Tutorial video can be found here: https://youtu.be/X-07IFvyA04. Until tomorrow, until next skybow Advent Calendar cookie.
 

Topics: Office 365, Sharepoint, SharePoint Online


Recent Posts

The skybow Partner Day & Awards 2019

read more

The New Strategy Alliance: Solutions2Share and skybow working closely together

read more

Working with fields in skybow Modern Forms

read more