News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Count of files in Shar...

Power Automate - Building Flows

Answered

Count of files in SharePoint Folder returns 100

(0) Share

Report

Report

Posted on by Community Power Pla...

I'm trying to build a Workflow that will first count the files in a SP Folder.

Now, although I have more than 100 files in the folder, I'm always getting 100. When It's below 100, I get the right number.

In Compose, I used the following expression:

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

So, how can I overcome this limitation?

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

creativeopinion 10,450 Super User 2025 Season 1 on at

Like (1)

Report

Re: Count of files in SharePoint Folder returns 100

Click on the three dots in the Get files (properties only) action and click on Settings.

Toggle on Pagination and adjust the threshold of items to return.

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉Watch my tutorials on YouTube
👉Tips and Tricks on TikTok

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans