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

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

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.

Adis Jugo

Written by Adis Jugo

is Director of Product Technology at skybow, and a software architect with over 20 years of experience. Adis is double Microsoft MVP (Most Valuable Professional) for Office Development and for Office Servers and Services. He first met SharePoint (and Microsoft CMS server) back in 2002, and since 2006 his focus was completely shifted towards architecture and development of productivity solutions, now based on the Azure, Office 365 and SharePoint technologies. Adis is an internationally recognized speaker with over 15 years of speaker experience, speaking at various Microsoft, Community and SharePoint/Office 365/Azure conferences worldwide.