Forum Discussion
Exceeding List View Threshold in Sharepoint Online
We are in the process of migrating SP on prem to the cloud, and we have a couple Finance libraries that we are moving that are in the 100k to 1.5million range. Needless to say, that violates the 5,0...
Ted McLaughlin , you can bypass the broken views by going to Site Contents and then Library settings and for each view that has been created, filter out files that were created before [X] date. That should 'unbreak' your ability to view and work with the files. (that's assuming that the migration tool that was used did not alter the original created dates).
You may need to create filtered views for each month to get under the view threshold. Which does not sound like fun. Would love to hear from someone else in the community if they have any ideas.
Please create index on created and modified field before using them in the view filters