How to create a flow that will report file count for a parent folder (and all nested sub folders). Count would be 1,000s.

[Dewroc]

Hello and Thanks In Advance for Guidance;

I searched the forums regarding the current need we have to get a file count for a set of nested folders/files in a folder in a SharePoint Doc Library. 

I have seen brief snippets around using Get.Files but everyone seems to indicate that it likely only targets one folder and maybe limited to 100 files. 

We would have nested folders (100s) needing a total file count (1,000s). 

[v-LilyW-msft · Accepted solution]

Hi @Dewroc 

According to your description, you want to count the files in a library’s folder include in subfolders.

Get files the default limit is 100, If you are using the default options, Power Automate returns 100 files from the library.

If you are working with many files more than 100, you can change this threshold limit to 5,000.

I set up a simple flow, you can refer to below screenshots.

After flow runs, 1090 files in my Document library will be count.

For more info about get file you can refer to:

https://docs.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-g...

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Dewroc]

This is a big step forward. Thanks.. 

But in my case, I have 10s of 1,000's of files..  Is there a solution that mimics a Windows File Explorer Right Click -> Properties function in SharePoint or Power Automate?

[v-LilyW-msft]

Hi @Dewroc 

Sorry, I don't quite understand.

Do you mean to filter out 10 files from these 1,000 files?

For example, count how many of these 1000 files whose file name is Book1.xlsx?

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.