How to find total files in SharePoint folder?

[MakeItReal]

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!!

[Soundharya · Accepted solution]

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

[MakeItReal]

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

[Soundharya]

Did you give correct library name and folder name?

[MakeItReal]

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]

Hi @MakeItReal ,

Please turn on pagination setting.

Best Regards,

Wearsky