Forum Discussion
Ted McLaughlin
Jun 18, 2019Brass Contributor
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,0...
Alan Marshall
Jun 18, 2019Iron Contributor
It is possible to have a large number of items in a view as long as the columns you are sitting by are indexed. I did this by creating the list, columns and indexes first and then migrate the data in, if you try to add an index after you have more than 5000 items it might not work. The Title column isn't always indexed either so it that would be a cause of your issue even though you have folders. Always keep the number of items to blocks of 100 for browser performance as it will fetch 100 at a time as you scroll.