How Can We Help?

Search for answers or browse about Sintel Forms.

How to avoid SharePoints list view threshold

You are here:

If you have worked with large lists in SharePoint, you may have received errors due to the threshold limitSharePoint is configured with a default threshold limit of 5000 items in a list. This means that if the items in a list exceed that number, any views, grouping and queries will fail. The other issue you may encounter is lookup column threshold – it’s maximum value is 12 per single list view.

In order to prevent the list view threshold issues when a form’s list grows in size, we have released an update that nests related items into folders. This will prevent any list view threshold issues.

Any list created after the update on the 29th of March 2022 will already have the threshold prevention setting enabled, hence any related items will already be located inside nested folders.
Any list created before the 29th of March 2022 will require explicit action to convert it to a threshold-safe version. 

How to enable the List view Threshold Prevention setting

If you think you might hit the list view threshold you can upgrade the list to the new behaviour in the Sintel Forms Designer:
  1. Go to Settings -> Basic features -> List Settings -> List View Threshold Prevention
  2. The slider is disabled and cannot be changed manually, although it indicates the proper state of threshold error prevention.
  3. To convert a list to the new behaviour, click the “Threshold Managementlink -> navigate to a new page.
  4. The page shows the current status of the operation and allows you to start it.
  5. Once started, the operation will take a while depending on the items count in all the lists and will convert the conversations and linked lists to the new structure.
  6. After that, any new item created will follow the anti-List View Threshold error convention.

How to deal with Lookup Column Threshold

If your list view includes lookup columns exceeding the threshold, you may encounter the following screen.

To fix the broken list view you must hide some lookup columns from the view. Ensure that the total number of lookup columns is equal to or less than 12:

  1. Click the cog icon (Settings) located on the top bar and navigate to “List settings”.
  2. Scroll down the page to the bottom and click the view to edit it (if you don’t have any custom views, itt’s called “All Items”).
  3. Uncheck some of the lookup columns and click “OK”.
Was this article helpful?
4 out of 5 stars
5 Stars 0%
4 Stars 100%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Table of Contents