Forum Discussion
How to find files over certain limit in SharePoint Library with hundreds of folders
Hi luvsql
You could also create a new View within the library, Save All Items as File Size.
Then edit the properties of this new view to be as follows
- Columns
- Tick to display File Size
- Sort
- First sort by the column , change to File Size
- Choose : Show items in descending order
- Folders
- Show all items without folders
This view will then show your biggest files at the top of the list.
To show files over a certain size, you would have to add a calculated column I think.
Dorje-McKinnon I just get the "something went wrong" after saving the new view. I think we have too many files. Anytime I try and use that File Size column it craps out.
- This will happen if the view returns more than 5000 items. Try adding a filter to the view to reduce the number of results - https://support.microsoft.com/en-us/office/use-filtering-to-modify-a-sharepoint-view-3d8efc52-0808-4731-8f9b-3dfaeacea3d4
I added the item limit to only 4900 and still receive the something went wrong. What I'm puzzled about is, SharePoint support hundreds of thousands of files in a library and also supports with good performance 300,000 files limit for sync to OneDrive. Why can't we filter or search or create views on libraries of this size without it failing if it supposed to store a lot more than 5000?
