what happens when a SharePoint online list/library exceed 30 million items/documents

john john 1,021 Reputation points
2022-11-12T23:01:05.25+00:00

I am reading the SharePoint online limitations @ https://learn.microsoft.com/en-us/office365/servicedescriptions/sharepoint-online-service-description/sharepoint-online-limits but i am not sure what will happen when a SharePoint online list/library exceed 30 million items/documents? will it raise a warning that the list/library no more accept new items/lists or it will stop opening even in read only view?

Microsoft 365 and Office | SharePoint Server | For business
Microsoft 365 and Office | SharePoint | For business | Windows
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Xyza Xue_MSFT 30,176 Reputation points Microsoft External Staff
    2022-11-14T02:11:32.647+00:00

    Hi @john john
    Technically, you can load over 30 million documents into sharepoint and not raise a warning. However, the speed will be significantly reduced. And we don't recommend you do it. Some unforeseen errors may occur.
    One document can have up to 30 million files and folders. One file must be less than 15 GB. And list view threshold is 5000.
    Note: When a list, library, or folder contains more than 100,000 items, you can't break permissions inheritance on the list, library, or folder.
    Others have had questions about the SharePoint 5000 item limit threshold, and if you also have questions, you can read this thread (hope it helps): https://learn.microsoft.com/en-us/answers/questions/1007253/sharepoint-online-5000-file-limit.html


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.