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).
Solved! Go to 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:
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.
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:
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.
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?
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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
User | Count |
---|---|
26 | |
25 | |
25 | |
22 | |
15 |
User | Count |
---|---|
50 | |
39 | |
35 | |
31 | |
30 |