LVT suddenly more picky: several views suddenly not working anymore
Hi, I have a client that has ~40k documents in a document library and this has been the case for years. Suddenly, two days ago, several flat views just stopped working with the dreaded "The attempted operation is prohibited because it exceeds the list view threshold" error message. I deleted 5k test documents to see if some sort of hidden threshold had been hit, but this didn't change anything. Something changed in the infrastructure, I believe. I also try to create routine views on other libraries with more than 5000 documents that always worked and don't anymore. I don't really want to go through the details of each affected views and the possible work arounds, but does anyone know if something changed lately in the SPO infrastructure about the LVT?
SharePoint list view threshold low down
List view threshold of 5000 items must be one of the most long-standing issues in SharePoint Online (SPO). It was there 4-5 years ago when I started out with SPO and it's still there. Recently, I had to deal with it again and decided to put together this summary that may help. Consider a list or library with over 100,000 items: This point is to clarify that list view threshold still applies even with modern experience UI in SPO. Modern UI only displays a small subset of data first and more items are displayed as user scrolls. Despite this, if there exist more than 5000 items in a view, the list view threshold error appears. 5000 item limit applies to containers and a folder is a container. Hence, a library can function normally if each folder within the library has less than 5000 items e.g. 100,000 items spread across 20 folders. Indexing columns improve performance and one way to get around 5000 limit is to index your columns and then create a view that filters on the index column to try to limit the number of items fetched in view below 5000. Display all items in view but only show indexed columns or use a group by on an index column. This works most of the times but still not 100% with list view threshold error encountered occasionally. The age-old desire of knowledge managers to have a flat structure and use metadata over folders can only be met if your library uses indexed columns as mentioned above. Be ready though as users may still report intermittent errors. Problem is mainly a data read error. If you filter your views to stay within the threshold limit then library will function normally, and users can add/edit data OK. If you build PowerApps on top of SharePoint large lists then be prepared to encounter the performance issues. You need to use delegation in PowerApps. However, if your app is popular and causes lot of traffic to SharePoint, it may get hit with throttling. For better performance, consider something other than SharePoint like SQL. Workaround that work If requirements is to report from a large library, use PowerBI If requirement is to sort, filter a large library then use Search. You can build a pretty solid functioning UI using https://microsoft-search.github.io/pnp-modern-search/.
Exceeding List View Threshold in Sharepoint Online
We are in the process of migrating SP on prem to the cloud, and we have a couple Finance libraries that we are moving that are in the 100k to 1.5million range. Needless to say, that violates the 5,000 list view threshold. What I can't understand is that on prem we have 10,000 set as the list view threshold, and I'm able to easily get into those libraries and click next, next, next, to page through each set of the 30 items that get brought back by the view. For some reason that doesn't work in SPO. I have the views set up exactly the same in SPO that we had on prem, but in SPO I just get the list view error and it won't show me any data. I've looked at this page: https://support.office.com/en-us/article/manage-large-lists-and-libraries-in-sharepoint-b8588dae-9387-48c2-9248-c24122f07c59?ui=en-US&rs=en-US&ad=US And this one: https://support.office.com/en-us/article/edit-a-list-view-in-sharepoint-online-15916903-e79a-423f-b4e2-02d37e1ff372 But neither of them help. I'm not trying to display 25k items at once, I just want to bring back 30 at a time and that's it.List view strange behavior SharePoint Online
Hello everyone, We have two test lists that has more than 5000 items. Below are the cases - List A - All item view does not work and we see List Throttling error. List B - All items view works fine with scrolling option. We see list throttling error when "Count" is being used on one of the fields. Not sure why this scrolling option works in List B and why not List A. Any insights is very much helpful.How do Documents Center and Records Center alleviate list view threshold?
It is found that Documents Center/Records Center templates being listed as one of several methods to circumvent the list view threshold restriction in SharePoint(SQL truly). I also understand now that if a single list vie is used in Documents Center/Records Center, the threshold (5000 by default) still applies. Question - How do Document/Records center solve the issue then if the restriction still there? Is it because these template offer a "searching/querying" interface vs. "browsing/traversing" interface? If that is the case, in essence, if a regular document library is used, as long as it is not showing the list view but have user search for it, would it achieve the same result then? I was under the impression that doc/rec center stores more documents than normal documents? If so, is that the only true advantage using doc/rec center vs. regular doc lib as far as solving the threshold issue goes? (ver. SharePoint 2013)
