Prioritize large list management in SharePoint Online
Large list management has to become a priority. Even with the most thought out and careful planning, inevitably something will come up and you need to make a change to a list or library. Once that goes over 5,000 items, it becomes impossible to do anything management related to the list, which actually hinders it's use. Users can continually add files, but you can't do anything to help them.
This has to be addressed in some fashion, whether it is allowing APIs like REST and CSOM to bypass this restriction so they can perform basic administrative operations or giving us a happy hour to perform tasks, something has to be done. Deleting 10s of thousands of files or moving them to temporary storage and back is cumbersome, time consuming, and can impact the userbase because their files go missing.
If nothing can be done, then TechNet NEEDS to indicate that the actual limit of SharePoint Online lists and libraries is 5,000 items, not the current architectural limit of 30 million.
When can we expect these updates?
We’re working on large list improvements in SharePoint Online.
Any updates on this?
It would be good to know what improvement exactly are in the pipeline. Is handling of lookup fields will be improived too? https://sharepoint.uservoice.com/forums/330321-sharepoint-search/suggestions/13002084-lookup-on-lists-over-5-000
Yes, you can do it!
finally this is going to change
TYVM Product Team!
Chandrashekar Kollipara commented
Amazing hope we can remove all millions of folders that were created just to help on 5000 limit
Dustin, neither have I when I'm under 5000, but once you go over 5000 items, you cannot create new indexes, therefore you can't create new views.
Many times now, we carefully plan architectures to store hundreds of thousands of files, many folders, none going over 5000 items. We thing we have everything accounted for, indexed columns the whole nine yards. Then something needs changed down the line, maybe it's a new column or a new index or permissions on a subfolder need changed to not inherit. If you are over the limit you just can't do a lot of these things.
Dustin Meany commented
I've never had any issues with large lists and using indexes.
Yes there are several out there, this one is more directed at increasing the priority of this issue as it pertains to their roadmap. It is a general we will get to it sometime in 2017, I'd like to see a specific quarter or date this is targetted for.
Search for "5000" here and see how many different items dance around this specific topic.