Forum Discussion
SharePoint online: index column 5,000 limit
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.
In addition to what has been mentioned, you could create an Information Policy that for example, moves items to another location after a certain age
Thanks to all for the great suggestions.
I can see now that better planning was needed from my end to index the columns before the migration of documents.
Brent Ellis I think I might go for option 2 as you mentioned.
Ian Moran Good point!
Cheers
The last few times i migrated docs, indexes were added automatically. If that is not happening for you, you may want to open a ticket with MS.
Dean_Gross Thanks Dean. Yes it seems that the indexing is not appening even though it is enabled on the library.
