Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Condition Apply To Each has a limit of 20

(0) ShareShare
ReportReport
Posted on by 11

Hi there,

 

I'm having a bit of a strange issue. I've created a Flow that looks at a table in Excel, and for each email seen in a column, it then sends an email with an attachment. 

 

As part of this, there is a condition where it checks the attachment name in a one drive matches the listed PDF name in the excel sheet. This works for the first 20 emails, then it just defaults to saying all from 20 - 60 are false, and doesn't send the email. I've tried a few different ways for this, but it's just not working, and I can't see why. 

 

Here is the flow - 

Screenshot 2021-04-07 at 16.53.29.png

Screenshot 2021-04-07 at 16.54.44.pngScreenshot 2021-04-07 at 16.54.57.pngScreenshot 2021-04-07 at 16.55.09.pngScreenshot 2021-04-07 at 17.04.32.png

  • JoeB1 Profile Picture
    11 on at
    Re: Condition Apply To Each has a limit of 20

    That's all it was!! 

     

    Thank you so much, wish that had been a little more clear!!

  • Verified answer
    dwalker97 Profile Picture
    82 on at
    Re: Condition Apply To Each has a limit of 20

    Hey

     

    It seems List Files in Folder step only reads in 20 files by default. You may be able to change this by changing pagination settings - https://natechamberlain.com/2017/11/11/how-to-change-microsoft-flows-default-limit-of-100-items-for-get-items-and-get-rows-actions/

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1