Forum Discussion

Damien Flood's avatar
Damien Flood
Iron Contributor
Sep 19, 2016
Solved

SharePoint online: index column 5,000 limit

Dear all,   Im working in a Sharepoint online document library with 20k + documents.   I would like to index one of the columns(creation date) in the library, but I am getting the 5,000 limit pro...
  • Brent Ellis's avatar
    Sep 19, 2016

    AFAIK, with SP Online, you don't have access to this.  Once you cross 5,000 (they may have been increased to 10,000 for admins or something like that recently), you are pretty much out of luck.

     

    Some quick options I have used in the past or are available in no particular order:

     

    Option 1: Create a new Document Library, with the same content types, columns, etc, and set up your indexes.  Create a script (e.g. PowerShell) to "MOVE", not "COPY" the files from Library 1 to Library 2.  Not terribly difficult, but does require some coding knowledge.

     

    Option 2 (will make you hold your breath, but it works):  Delete ALL of the items in the library (send them to the recycle bin).  Then you can turn on the Indexes, and then restore the deleted items from the recycle bin.

     

    Option 3:  Third party tools.

Resources