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.

View solution in original post

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,725)