Remove the list view threshold (5000 by default)
This limit has always been a bit laughable, and is even more so as we develop more client side applications. In SharePoint 2007 we didn't have this limit and were allowed to make our own mistakes. Now that hardware is so much more powerful, we need this limit removed so that we can build enterprise-class applications.
We are continuing to make our large list experiences better, please keep the feedback coming.
Spring 2018 update:
- We now support being able to manually add indexes to lists of any size (increased from lists up to 20,000 items previously).
- Starting with the February release of the Office 365 Excel client, you will be able to export your full list instead of getting cut off part of the way through.
What we are working on now:
- Predictive indexing will start to work for lists larger than 20,000 items so your views will automatically cause the right indexes to be added to your lists.
In our backlog:
- Being able to index/sort/filter by lookup column types (like person, lookup or managed metadata columns) without being throttled.
- Making sure that our REST APIs support querying in ways that will guarantee that the call will not be throttled.
For a general update on large list capabiltiies, the video on myignite.microsoft.com/videos/53861 (focusing on large lists at 42 minutes and 25 seconds) describes some of the changes that we delivered back in the second half of 2017:
- Modern UI now has a lot of support for adding indexes to large lists and libraries on the fly, reducing the number of throttling errors experienced by our users, and some new UI for browsing through items in large lists with our paging model
- SharePoint runs predictive indexing jobs to automatically add indexes as lists get larger based on your view definitions, and updates these indexes when you add/update your views
Looking forward to receiving more of your feedback.
Alex R commented
Microsoft Documentation states a library will support up to 30 million items.
But after 100,000 items, you can no longer manage permission inheritance!
So in reality, SPO only fully supports libraries with up to 100,000 items.........
Tanveer Hirani commented
I have designed a library for sharing with internal staff and customers (via folders) for individual property/buildings. The library is expected to have more than 50,000 documents added each year by contractors! Even though I have created almost 20 different views, I really need a view with more than 5,000 documents! Because of the nature of our business. It is critical that this limit is removed for my solution and design to work which is around integrating 10 teams within my department and move away from network/windows explorer based filing/document management system.
Another issue that I have is that I cannot index multiple values Managed Metadata columns which makes my document library kinda useless. Please try improve or remove this limit.
Brendan Murphy commented
Just hit this issue today "- Being able to index/sort/filter by lookup column types (like person, lookup or managed metadata columns) without being throttled." My solution is dead in the water because of this. This is really ridiculous. Now I have to come up with some convoluted way to move items from one list to another and keep the history so that my lookup column will work. I've been a big SP fan, but since moving to SPO, I'm becoming less and less of one.
Rajendra Katta commented
Microsoft - Migration of large lists from SharePoint On-premise to SharePoint online is getting horrible, Some of the lists have 100k items migrating them into SharePoint Online is useless after migration. Please increase the Limit ASAP. The clients are absolutely disappointed with Threshold limit.
Microsoft - please do something about this limit ASAP! SharePoint lists are useless for business applications where you have more than 10 users that add items on a daily basis.
Maamar Bouzada commented
We need to extend the limitation of 5000 items view to bigger .
What is happening to this? This problem needs an urgent resolution. Almost every SP site we have will exceed 5000 files. It is severely impacting our ability to use SP at the enterprise level.
Marco Garibay commented
One year since the last update and nothing yet?
Speaking for our team, we just want to use sharepoint as a file repository and so far it's been a nightmare.
I'd like to see a sharepoint container that behaves exactly like a onedrive, with zero limit of file size transfer.
This is important as we use onedrive to store video files which go above 5GB
Please remove this block.
Please increase the number. It is urgent!
Please fix this Microsoft.
PLEASE PLEASE PLEASEEEE Microsoft do your thing to improve this! Looking at the number threads and complaints this is already long overdue.
I literally had to delete a whole document library because LVT wouldn't let me break permission inheritance for that library. The trick was to view that library in File Explorer and delete everything from there.
Then I have to migrate the library again which means extra down time for the users.
This is so frustrating. Even a work around where it only displays the first 5000 results will be better than displaying nothing at all.
agree with the comment that there has been no response in a year on this topic of the 5000 limit. Please update us.
Can we please have an update on this. It is a year on now from the 'Working On It' reply.
I would like to see a Sorting function added that allows you to easily select a way to filter your Sharepoint by the last X amount of Days or years. Right now there is a 'Created' field, but it is not easy to apply a date filter there that goes back a certain amount of time since it seems these fields have to be a static number. I see this as being valuable to a lot of different admins.
Sven W. commented
any update on the issue not being able to filter on Managed Metadata columns in large lists although they are indexed?
Jeff Joubert commented
Since we had a Spring 2018 update, could we get a Spring 2019 update?