cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dewroc
New Member

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

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). 

1 ACCEPTED SOLUTION

Accepted Solutions
v-LilyW-msft
Community Support
Community Support

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.

vLilyWmsft_0-1625808109014.png

vLilyWmsft_1-1625808109019.png

vLilyWmsft_2-1625808109021.png

vLilyWmsft_3-1625808109023.png

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

vLilyWmsft_4-1625808109027.png

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.

View solution in original post

3 REPLIES 3
v-LilyW-msft
Community Support
Community Support

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.

vLilyWmsft_0-1625808109014.png

vLilyWmsft_1-1625808109019.png

vLilyWmsft_2-1625808109021.png

vLilyWmsft_3-1625808109023.png

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

vLilyWmsft_4-1625808109027.png

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
New Member

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
Community Support
Community Support

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?

vLilyWmsft_0-1626146679128.pngvLilyWmsft_1-1626146720106.png

Best Regards

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

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (3,730)