We have a couple of document libraries in which there is a large amount of data.

i.e., one of the document libraries has 1,99,936 items in it.

We are looking for the best archival option so that the current site doesn't get slow due to a large amount of data and also we want to avoid the issues with Search as the threshold limit is crossed.

Below are some of the options we found for the Archival of SharePoint Online Document Library,

  1. Manually move the older files to other locations / delete them.
  2. Set retention policy.
  3. Create a flow on a particular document library to move the files to other locations over a specific time period.

Is there any other option available for the archival?

Thanks in advance.

2 Answers 2


Sites don't get "slow" due to data set size. If you do find any performance issues, you can open a case with Microsoft as performance is their responsibility.

  • Yes I agree with you but we also want to avoid issues with search. Commented Mar 16, 2021 at 5:14
  • Search can handle hundreds of millions of files so I don't know what issues you're expecting to encounter.
    – user6024
    Commented Mar 16, 2021 at 14:52
  • So currently, we are facing the issue where some of the action buttons like, Move To and Copy To are not appearing or not working if users are searching in these document libraries which has more than 2lac items Commented Mar 16, 2021 at 15:34

You can refer to the following two methods. These methods are more of a “workaround” and not a true archival technique.


The idea behind this approach is that you would be setting up unique permissions for certain folders you need to “archive”, thus making them invisible to the end-users. So, in reality, folders will still be there, just hidden.


  • Folders/Files cannot be hidden from the Site Owners/Site Collection Administrators.Only Site Members and Site Visitors.


The idea behind this method is that you will need to create a custom metadata column on a library called “Status” (or whatever you want to call it) with a few drop-down choices (i.e., Active/Inactive). Once tagged, this will allow you to filter out (hide) the Inactive files.


  • Can only tag files, not folders
  • Requires consistency in tagging if you would like to utilize across multiple sites/libraries
  • Hi, Litt Spector. If there is any solution in the future, I will share with you as soon as possible. Have a nice day! Commented Apr 5, 2021 at 9:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.