Unanswered

Apply to Each limitation

(3) Share

Report

Posted on by Community Power Pla...

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.

Categories:

Building flows

I have the same question (1)

All responses (17)

Answers (1)

v-micsh-msft on at

Like (2)

Report

Hi @Anonymous,

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

Limits and configuration in Microsoft Flow

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

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?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (4)

Report

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

Was this reply helpful? Yes No
ChrisCC 42 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (6)

Report

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

Was this reply helpful? Yes No
ChrisCC 42 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

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

Thanks All.

Was this reply helpful? Yes No
ErichH 322 on at

Like (0)

Report

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 FlowPart 2 of flowexpanding 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

Was this reply helpful? Yes No
Tangi12 32 on at

Like (4)

Report

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

Was this reply helpful? Yes No
Tangi12 32 on at

Like (1)

Report

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

Was this reply helpful? Yes No