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.
So 2 years no update. Please give us feedback. We need that soon.
I had today an case where i needed to share a folder with ~1500 Subolders and multipe subfolder structures and in total 132.000 files to other users. I wasn able to do that. Kinda frustration. I got theese files from box.com and box.com was able to share that amount of data.
Why still limit only 5.000 until now? Hope can resolved ASAP
guys, no is looking at it, so just leave it on it's own and live with it.
Jeffrey Oliver commented
Welcome to Use(less)voice!
Steve D commented
I am beginning to think we will put people on Mars before this gets fixed.
Working hard on it?
Frank S commented
Yes we need this fixed, how long are you working on it?
Jessica Kline commented
Seriously? No updates since Spring 2018. Please fix this issue.
I spent the last year transitioning our main platform to spo...and every one hates it. Even though all indexing on, views break on the daily
Baka Nick commented
It's 2020 and the threshold is still there. They've promised a workaround for years. Is it really hard for them to simply remove this threshold? I doubt so. But they just aren't doing it. Microsoft, it's 2020 not 1980. Make SharePoint great again.
Hi, is there any update or even a suggestion for workaround? Is this site still monitored and heard by @Microsoft?
Ketak Bhalsing commented
If count of the list item exceeds 20000, we are unable to create Calculated Column or even modify existing calculated column formula.
Not Bill Gates commented
@Microsoft is there any sort of update on this?
Tuan Tran commented
Please fix this issue, it is the end of Apr 2020 and we have TB of storage space at SharePoint/ OneDrive but we are unable to share, rename, delete folders that have more than 5000 files. We don't have that issue with Google Drive, Dropbox, Box and other cloud storage solution. Thank you for your hard work.
This limit is crazy! We can't rename or even DELETE folders with >5000 files without custom code!! BOX has been able to do this for 15 years!
Martin Coupal commented
@Jeffrey, you can use Power Query in Excel to get more than 5000 items. Just create a new excel file, go to data tab and get data from SharePoint list data source. You should be ok.
Jeffrey Oliver commented
It's now April 2020, my Excel client is STILL not able to retrieve the contents of a list with more than 5000 items. I get an error that says the list item threshold has been exceeded. So frustrating!
Manish Sati commented
Would love this feature to be available soon!!
Tanveer Hirani commented
I must say this is very frustrating! We have gotten around this issue by exporting documents in excel using PowerShell. However, it is not an easy task! Can PowerShell be automated?