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

john john 946 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?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,244 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,892 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Haoyan Xue_MSFT 22,146 Reputation points Microsoft Vendor
    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.