Forum Discussion
Exceeding List View Threshold in Sharepoint Online
Any suggestions on what I can do with a library that has 1.5 million items, (invoices), that are broken out by year, month, day that the invoice was scanned in. We have a folder off the root of the library for 2015, then a 01 month sub folder, than a subfolder 05 for the day. That day might have 50 invoices that got scanned that day.
There is no metadata on these items other than the basic title, last modified date & user, etc. I have nothing other than that to filter on.
I don't know of any way I could add any metadata to a library like this, nor any way that I could re-arrange the data. Especially now that all this data is in the cloud and I can't really access it. I admit I haven't tried to do anything with powershell against this library because i can't figure out anything to do.
Thanks for your help with this.
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
