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

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

Highlighted
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

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.

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

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 146 members 3,699 guests
Please welcome our newest community members: