We migrated around 25000 files from network share to SharePoint Online. However, of these, around 1400 of them were migrated to the root folder which shouldn't have happened and we would like to delete these.
My SharePoint site is https://myclient.sharepoint.com/sites/dynamics365production/. Within this, I have a library called as Opportunity and within that I have a number of folders each of which has zero or more documents. However, there are around 1400 files available at https://myclient.sharepoint.com/sites/dynamics365production/opportunity.
What I want to be able to do is, delete only files which are at this level. The files which exist in the folder https://myclient.sharepoint.com/sites/dynamics365production/opportunity/FolderA and https://myclient.sharepoint.com/sites/dynamics365production/opportunity/FolderB should continue to exist.
How do I do it?
Here is what I have tried to do so far.
- If I try to create a view, so that I can sort and see all the files at the top I get the following error message.
This view cannot be displayed because it exceeds the list view threshold (5000 items) enforced by the administrator.
To view items, try selecting another view or creating a new view. If you do not have sufficient permissions to create views for this list, ask your administrator to modify the view so that it conforms to the list view threshold.