cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tomgibson
Level: Powered On

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

Re: Apply to Each limitation

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

8 REPLIES 8
Community Support Team
Community Support Team

Re: Apply to Each limitation

Hi @tomgibson,

 

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.
tomgibson
Level: Powered On

Re: Apply to Each limitation

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

Re: Apply to Each limitation

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

ChrisCC
Level: Powered On

Re: Apply to Each limitation

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

Re: Apply to Each limitation

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

ChrisCC
Level: Powered On

Re: Apply to Each limitation

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

 

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

tomgibson
Level: Powered On

Re: Apply to Each limitation

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.

Highlighted
Super User
Super User

Re: Apply to Each limitation

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"

 

Apply2Each_1.PNGStart of FlowApply2Each_2.PNGPart 2 of flowApply2Each_3.PNGexpanding 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

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (6,379)