Forum Discussion
SharePoint online: index column 5,000 limit
- 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.
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.