SharePoint Document Library limit of 5000 - Ridiculous
We planned to migrate from Dropbox to a SharePoint document library and when implemented, we immediately hit the 5000 item limit in a library. This is ridiculous in 2018. We have used folders with over 35,000 files on Dropbox without any issues. This is an unfortunate limit for a product that is called Office365 for business.
Please increase this limit or provide another means to load and backup large datasets.
I generate 3500 files of the same kind a year and I am not able to have them in the same view. Not even with a group function. Ridiculous.
My system generates in one measurment 8000 files. I am not able to hot them together in a folder on SharePoint. Ridiculous.
I have to stay on a local server till this issue is fixed.
Yes, I agree it is ridiculous. The limit should be higher or maintainable by the admin.
Mark Ernst commented
It IS ridiculous. It's just a really ****** service of Microsoft to be offering a TB of space, limited to 5.000 items. You can never use that TB of space with that small amount of files. I have 259.000 files and it's still not a TB.
Matthias Fleschütz commented
+3 votes for this and thanks for that appealing title @Rodney
Same use case here...plan to migrate from Dropbox to SharePoint.
At least one document library has ~25000 files with 6.300 elements.
At this point I don't wanna think about migrating our internal fileservers to Sharepoint doc libraries...
-1 of my votes as there seems to be only partial limits:
"You can store up to 30 million items or files in a SharePoint list or library. Filtered views of large lists have a similar experience to other lists. However, when a list view shows more than 5000 items, you may run into a list view threshold error. Follow one or all of the three steps below to update your list when you do."
So it seems that it works for those libraries, but you will get problems in lists / filters / indexes.
Here it is 2019 and this feature has not been added. This is a must as a lot of corporation have folders that contain over 5k documents
I agree, this limitation is very restrictive and unnecessary. I also feel such a limitation should be documented well in the marketing materials. Their advertisements of "up to 30 million items" is very misleading.
The limitation is a real problem so Microsoft please help your faithful customers
This is much needed feature and this screwed up many sites after the migration and still many of them does not work with the workarounds. This is bad design and bad planning.
Prakash Gupta commented
Please provide the option to change thersold limit, so that we can decide as per our requirement
I have libraries on prem with ~140,000 items. I have lifted the list view threshold to 150,000 items. This is not that taxing on SQL server or the WFE. It takes a couple seconds to open a folderless view (flat list) of a library with 148,000 files. People are accepting of this because they realize there are nearly 150,000 files and they are fine with a 2-3 second wait. (probably would be 5-6 seconds in SharePoint online). Note, when opening a regular folder view of the same library it doesn’t take any longer than usual.
If Microsoft raises the limit and people see the minor slowdown in large libraries/views, they will have an understanding of why with some simple explanation. They are then enabled to decide between a minor performance hit or the pain of reorganizing their content. The important point here is the customer is not limited, they are empowered to decide for themselves.
Now for another angle. No competing document management system has such a constraining limitations. Without removing these barriers I'm afraid Microsoft is going to continue losing large amounts of customers to Box, G-Suite, and others.
Finally OneDrive (sharepoint mysites) don't have this problem, so why stick it in SharePoint? Or am I to conclude OneDrive is no longer using a SQL back end?
Matt Barker commented
We have moved some departments into Office 365 groups with over 140,000 files. As soon as they started sharing files and links our ability to share and change folder names ceased due to the list view threshold. Microsoft should highlight the 5,000 file limit. They train you to share files and folders without saying that this breaks inheritance and will cause any folders containing more than 5,000 files to start doing weird things. And changing views does nothing. This is an inherent flaw in their system.
Matthew Bell commented
Matthew Bell commented
Yes, totally agree