web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : fE66trmvsbG0VbJGCY+Cff
Power Automate - Building Flows
Answered

Condition Apply To Each has a limit of 20

Like (0) ShareShare
ReportReport
Posted on 7 Apr 2021 16:06:03 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

I have the same question (0)
  • JoeB1 Profile Picture
    11 on 07 Apr 2021 at 16:36:25
    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 07 Apr 2021 at 16:10:48
    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading started
Loading complete