cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MakeItReal
Frequent Visitor

How to find total files in SharePoint folder?

Hello

 

I have a Teams group and i am trying to build a Flow that would send a weekly email with the total number of files/items in that group SharePoint folder (it has many subfolders with files).

 

Any help is much appreciated!!

1 ACCEPTED SOLUTION

Accepted Solutions
Soundharya
Helper III
Helper III

length(outputs('Get_files_(properties_only)')?['body/value'])

Soundharya_1-1643650920851.png

 

 

View solution in original post

5 REPLIES 5
Soundharya
Helper III
Helper III

length(outputs('Get_files_(properties_only)')?['body/value'])

Soundharya_1-1643650920851.png

 

 

@Soundharya Thank you for your response.

 I did exactly as you suggested but i get only 100 files as the result and there are way more than 100! Could you please advise?

 

For this line of code: 

length(outputs('Get_files_(properties_only)')?['body/value'])

Should i change anything? I just copied and pasted it as an expression in Compose.

 

MakeItReal_0-1643654969100.png

 

MakeItReal_1-1643655177980.png

 

Did you give correct library name and folder name?

Soundharya_0-1643702677752.png

 

Yes. I followed all your instructions. I think there is a limit of 100 by default?

https://alextofan.com/2019/08/22/how-to-get-more-than-5000-item-from-sharepoint-online-in-flow/

v-xiaochen-msft
Community Support
Community Support

Hi @MakeItReal ,

 

Please turn on pagination setting.

vxiaochenmsft_0-1643786072843.png

 

Best Regards,

Wearsky

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,744)