SharePoint Online lists and document libraries have a 5,000-item limit for filtering data. You could quickly reach that threshold if you want to use a single SharePoint site to house many projects or a large multi-year project.
Read on to discover how Construction Viz can overcome the 5K threshold, continue delivering robust analytics for your projects, and keep ticking regardless of the threshold limit.
SharePoint lists and libraries can store up to 30 million records. At 5,000 records, however, filtering views stop working. And with SharePoint Online, there is no way to change that threshold.
You could re-index the list or library, adding one or more indexes to the list columns, which will fix the error message. However, exceeding the threshold will still adversely impact SharePoint’s functionality. Specifically, column filtering is limited, and lookups can be adversely affected. Removing columns from views can help, but ultimately, you will have a different experience after you hit the threshold.
Construction Viz Solves the 5K Item Limit in SharePoint Online
Since organizations may need to manage one or many projects in a single SharePoint site, with Construction Viz for Microsoft 365, we built controls to keep your projects running smoothly regardless of the threshold. So, even if you have not implemented indexing on the SharePoint list or library, Construction Viz can continue delivering analytics and reporting.
With Construction Viz, we take the best of Microsoft 365, fill in any gaps, and deliver a second-to-none project management information system in your Microsoft environment.
Click here for a free demo and consultation to learn how Construction Viz can save you time and money while keeping your data safe in your Microsoft 365.