Jun 02 2022 04:17 AM
Hello All,
I have uploaded multiple folder in SharePoint Site, but many files failed to upload.
So now I wants to check in SharePoint that particular folder contain how many subfolders and total files.
Like in windows we right click on folder and hit on properties so it shows total number of files in particular folder.
So can anyone help me for that in share point?
Note: I have multiple subfolders so "Item Child Count" and "Folder Child Count" columns not useful for me.
Thanks,
VP
Jun 02 2022 06:58 PM
Jun 02 2022 07:12 PM
@PamDeGraffenreid Can you pls explain me step?
Jun 03 2022 07:48 AM - edited Jun 03 2022 07:49 AM
Jun 03 2022 08:49 AM
Solution@VPatel21 Here you go
1- Export to Excel
2 - Open the downloaded file into Excel. You may get a security prompt, click Enable. The table will be selected by default when it opens.
3 - Go to the Insert Tab, and select Pivot Table
4 - Configure your PivotTable fields like this...
Result:
At the top level there are 4 folders and two files
Every folder has a unique path, so for each path (folder) - you'll get a count of files and folders.
Good luck!
Jan 22 2024 07:33 AM
Apr 16 2024 01:07 PM
@PamDeGraffenreid great tip with excel export but how to do with hundreds of thousands files?
Jun 03 2022 08:49 AM
Solution@VPatel21 Here you go
1- Export to Excel
2 - Open the downloaded file into Excel. You may get a security prompt, click Enable. The table will be selected by default when it opens.
3 - Go to the Insert Tab, and select Pivot Table
4 - Configure your PivotTable fields like this...
Result:
At the top level there are 4 folders and two files
Every folder has a unique path, so for each path (folder) - you'll get a count of files and folders.
Good luck!