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.

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.
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