Fix view of displaying files in a document library with ~60,000 items

Vikharankar, Vishakha 20 Reputation points
2024-07-03T07:10:37.14+00:00

I need to display all the files in a SharePoint Online document library with approximately 60,000 items.
However, the library is not displaying any files. I already attempted to create a new view with filters on indexed columns, but it did not resolve the issue.
How can I make sure all items - including folders, files, and files inside folders - are visible? Note that the library will continue to grow by about 400-500 items each month.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,151 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,783 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Du-MSFT 43,511 Reputation points Microsoft Vendor
    2024-07-04T07:27:03.47+00:00

    List view threshold is a limit of 5000 items in the SharePoint online, which can’t be exceeded. Even if a view has filters on indexed columns, the view must have less than 5000 items to ensure better performance.

    The best choice to solve this issue is to create folders for each month in the document library, and in each folder make sure files are less than 5000.

    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.

    0 comments
  2. Vikharankar, Vishakha 20 Reputation points
    2024-07-04T12:36:35.92+00:00

    Even if a view has filters on indexed columns, the view must have less than 5000 items to ensure better performance.

    In this case where filters are applied on indexed columns, will the view break or will it just be slow?
    What is the exact number of items in document library above which it will break?