cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Apply to Each limitation

Hello,

 

I've had a look around and not found an answer to this one yet;

 

I've created a flow that copies all the files from a Box folder to a Dropbox folder every x hours. The flow works fine, however the Apply to Each action seems to have a 100 iteration limit - I only see 100 files in the Dropbox folder, and 100 actions on review.

 

The issue is that we have 150+ (and potentially growing) files in Box. Is there a way to increase this limit or a workaround that will copy all the files?

 

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

I beleive this was fixed in a recent update

 

Advanced options under 'Get Items' has a maximum get count which you can manually set to whatever you want

View solution in original post

16 REPLIES 16
v-micsh-msft
Community Support
Community Support

Hi @Anonymous,

 

Please check the article below for the limits under Microsoft Flow:

Limits and configuration in Microsoft Flow

109.PNG

So I don't think the issue here is caused by the Apply to Each limitation.

Would you please share some details about the flow configuration, are you using the Box->List files and Folders in a folder action?

In addition, please verify the Body output of the Box->List files and folders in a folder action, confirm that it has all the files loaded.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi @v-micsh-msft,

 

Thanks for looking at this. Yes, I'm using the List files and folders action. I just checked this and it looks like this might be the culptit as I can only see 100 items in the List action results.

 

Here's a copy of the flow as it is now. Are you aware why the List action might be only pulling 100 items?

 

Flow

Anonymous
Not applicable

Answer to this would be great as I am looking at a smilar issue.

I'm currently having this issue with a SP list - apply to each on every item in the list. It does not iterate beyond 100

Anonymous
Not applicable

I beleive this was fixed in a recent update

 

Advanced options under 'Get Items' has a maximum get count which you can manually set to whatever you want

I see that now, appears to have fixed it. Thank you!

 

My existing flows have defaulted to 100 items instead of 512 FYI

Anonymous
Not applicable

I just checked, and this has resolved for my flow too. I didn't have to change anything it just updated.

Flow.PNG

 

Thanks All.

ErichH
Kudo Kingpin
Kudo Kingpin

I have the same issue today. I had 157 items in the sharepoint list, used an ODATA filter string to get the relevant 119 records.

 

yet only 100 records are read by "GET ITEM"

 

Start of FlowStart of FlowPart 2 of flowPart 2 of flowexpanding on the condition where the apply to each is programmed.expanding on the condition where the apply to each is programmed.

see also

https://powerusers.microsoft.com/t5/Building-Flows/get-items-only-returns-100-records/td-p/136883

I do not see an advance setting selection...is there another workaround?  Thanks so much for your help!

Never mind!  I answered my own question.  The pagination is on the get items, not at each... Thanks!

ptempleton
Helper II
Helper II

I am having this issue as well... I do not see an advanced setting for adding more iterations.  I have a folder that receives 300+ files a day and a flow that moves the files out of the received folder into a processing folder but it is only moving 100 files.  This is creating a major bottle neck on file processing.

prashanthspark
New Member

I am facing an issue where Get Items consume 3ms whereas Apply to Each takes 5 days 

I have been iterating on a large list having 15k+ items which show the threshold already as it crossed 5k limit

 

As a workaround, I tried breaking the item limit < 2500 per each based on ID to run the parallel power automate instance (all instance are separate on their own)

 

Any idea how can we tune this - "Apply To Each loop"

 

prashanthspark_0-1616644813153.png

 

  

@prashanthspark  following this to know any suggestions/solution as well.

I found that if iterating through more than 1000 records will cause the flow to run disproportionately slower (e.g. 500 records take 1.5 hours, but 1500 records take 24+ hours). And when I break them up manually into separate instances, it runs much faster. Would love to know how I can optimize this.

Or does anyone know how to build a flow which can automatically break the 'apply to each' loops to 500 records each (e.g. if 2100 records, break it into 5 loops: 500 + 500 + 500 + 500 + 100)

Anonymous
Not applicable

apply all.JPG

Can you use apply all to update all the rows in a excel table? Essentially this would reset the table to have all internal columns updated. I have tried update a row but the flow tends to get very long one for each person.

I am having the exact same problem. When I filter the results to 500 records or so, the flow runs in a few minutes. But I have to run the flow to 8,000 records. So it runs for days.

 

Did you ever find a solution to split the apply to each in 500 records batch?

Ashkan
New Member

1-Click on get items

2- In the setting tab turn on Pagination and change the ThresholdAshkan_0-1702579276792.png

Ashkan_2-1702579324975.png

 

Helpful resources

Announcements

Super User of the Month | Drew Poggemann

As part of a new monthly feature in the Community, we are excited to share that Drew Poggemann is our featured Super User for the month of February 2024. If you've been in the Community for a while, we're sure Drew's name is familiar to you, as he is one of our most active contributors--he's been a Super User for five consecutive seasons!   Since authoring his first reply 5 years ago to his 514th solution authored, Drew has helped countless Community members with his insights and expertise. In addition to being a Super User, Drew is also a User Group leader and a Microsoft MVP. His contributions to our Super User sessions and to the new SUIT program are always welcome--as well as his sense of humor and fun-loving way of sharing what he knows with others.   When Drew is not solving problems and authoring solutions, he's busy overseeing the Solution Architecture team at HBS, specializing in application architecture and business solution strategy--something he's been doing for over 30 years. We are grateful for Drew and the amazing way he has used his talent and skills to help so many others in the Community. If you are part of the SUIT program, you got to hear some great tips from Drew at the first SUIT session--and we know he still has much more to share!You can find him in the Community and on LinkedIn. Thank you for all you do, Drew!

Announcing Power Apps Copilot Cookbook Gallery

We are excited to share that the all-new Copilot Cookbook Gallery for Power Apps is now available in the Power Apps Community, full of tips and tricks on how to best use Microsoft Copilot as you develop and create in Power Apps. The new Copilot Cookbook is your go-to resource when you need inspiration--or when you're stuck--and aren't sure how to best partner with Copilot while creating apps.   Whether you're looking for the best prompts or just want to know about responsible AI use, visit Copilot Cookbook for regular updates you can rely on--while also serving up some of your greatest tips and tricks for the Community. Our team will be reviewing posts using the new "Copilot Studio" label to ensure we highlight and amplify the most relevant and recent content, so you're assured of high-quality content every time you visit. If you share a post that gets featured in the curated gallery, you'll get a PM in the Community to let you know!The curated gallery is ready for you to experience now, so visit the new Copilot Cookbook for Power Apps today: Copilot Cookbook - Power Platform Community. We can't wait to see what you "cook" up!    

Celebrating a New Season of Super Users with Charles Lamanna, CVP Microsoft Business Applications

February 8 was the kickoff to the 2024 Season One Super User program for Power Platform Communities, and we are thrilled to welcome back so many returning Super Users--as well as so many brand new Super Users who started their journey last fall. Our Community Super Users are the true heroes, answering questions, providing solutions, filtering spam, and so much more. The impact they make on the Communities each day is significant, and we wanted to do something special to welcome them at our first kickoff meeting of the year.   Charles Lamanna, Microsoft CVP of Business Applications, has stressed frequently how valuable our Community is to the growth and potential of Power Platform, and we are honored to share this message from him to our 2024 Season One Super Users--as well as anyone who might be interested in joining this elite group of Community members.     If you want to know more about Super Users, check out these posts for more information today:    Power Apps: What is A Super User? - Power Platform CommunityPower Automate: What is A Super User? - Power Platform Community Copilot Studio: What is A Super User? - Power Platform Community Power Pages: What is A Super User? - Power Platform Community

Super Users 2024 Season One is Here!

   We are excited to announce the first season of our 2024 Super Users is here! Our kickoff to the new year welcomes many returning Super Users and several new faces, and it's always exciting to see the impact these incredible individuals will have on the Community in 2024! We are so grateful for the daily difference they make in the Community already and know they will keep staying engaged and excited for all that will happen this year.   How to Spot a Super User in the Community:Have you ever written a post or asked for help in the Community and had it answered by a user with the Super User icon next to their name? It means you have found the actual, real-life superheroes of the Power Platform Community! Super Users are our heroes because of the way they consistently make a difference in the Community. Our amazing Super Users help keep the Community a safe place by flagging spam and letting the Community Managers know about issues. They also make the Community a great place to find answers, because they are often the first to offer solutions and get clarity on questions. Finally, Super Users share valuable insights on ways to keep the Community growing, engaging, and looking ahead!We are honored to reveal the new badges for this season of Super Users! Congratulations to all the new and returning Super Users!     To better answer the question "What is a Super User?" please check out this article: Power Apps: What is A Super User? - Power Platform CommunityPower Automate: What is A Super User? - Power Platform Community Copilot Studio: What is A Super User? - Power Platform Community Power Pages: What is A Super User? - Power Platform Community

Did You Attend the Microsoft Power Platform Conference in 2022 or 2023? Claim Your Badge Today!

If you were one of the thousands of people who joined us at the first #MPPC Microsoft Power Platform Conference in 2022 in Orlando--or attended the second-annual conference in Las Vegas in 2023--we are excited to honor you with a special community badge! Show your support for #MPPC Microsoft Power Platform Conference this year by claiming your badge!           Just follow this link to claim your badge for attending #MPPC in 2022 and/or 2023: MPPCBadgeRequest    Want to earn your badge for 2024? Just keep watching our News & Announcements for the latest updates on #MPPC24.

Microsoft Power Platform | 2024 Release Wave 1 Plan

Check out the latest Microsoft Power Platform release plans for 2024!   We have a whole host of exciting new features to help you be more productive, enhance delegation, run automated testing, build responsive pages, and so much more.    Click the links below to see not only our forthcoming releases, but to also try out some of the new features that have recently been released to market across:     Power Apps  Power Automate  Copilot Studio   We can’t wait to share with you all the upcoming releases that will help take your Power Platform experience to the next level!    Check out the entire Release Wave: Power Platform Complete Release Planner 

Users online (2,549)