How Can We Help?
Search for answers or browse about Sintel Forms.
How to avoid SharePoints list view threshold
If you have worked with large lists in SharePoint, you may have received errors due to the threshold limit. SharePoint 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:
- Go to Settings -> Basic features -> List Settings -> List View Threshold Prevention
- The slider is disabled and cannot be changed manually, although it indicates the proper state of threshold error prevention.
- To convert a list to the new behaviour, click the “Threshold Management” link -> navigate to a new page.
- The page shows the current status of the operation and allows you to start it.
- 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.
- After that, any new item created will follow the anti-List View Threshold error convention.