Unanswered

Error: Action 'Apply_to_each' failed when run Flow Alert onboard MDATP

(0) Share

Report

Posted on by hovanviet1292

Hi all,

I created a auto flow to send mail alert when has new Devices onboard Microsoft Windows MDATP, refer link: https://docs.microsoft.com/en-us/microsoft-365/security/defender-endpoint/onboarding-notification?view=o365-worldwide

But at 4 step "Apply_to_each" has error "Action 'Apply_to_each' failed".

Error details:

Unable to process template language expressions for action 'Apply_to_each' at line '0' and column '0': 'The number of foreach items limit exceeded for action 'Apply_to_each': maximum '5000' and actual '5794'.'.

Please help me fix.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

Sundeep_Malik 6,484 on at

Like (0)

Report
Copy link

Link copied!
Hey @hovanviet1292
Not sure but with different licenses you can get more items from get items.
Try some workarounds:
Go to settings of get items and open the option of pagination and increase threshold from 5000 to 6000.

If the above didnt work try to decrease the items by adding something in filter query of get items.
If 2nd method also didnt work, use two get items, in first get items give top count as 5000, and in the second get items, give skip count 5000.

I hope these steps help.

Was this reply helpful? Yes No
hovanviet1292 6 on at

Like (0)

Report
Copy link

Link copied!

Hi @Sundeep_Malik ,

Thanks for your support,

I am new member, i tried follow 1 method but my license cannot change to 6000.
with 3nd method, how to create 2 get items.

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report
Copy link

Link copied!

Hey @hovanviet1292
just use them in parallel.
Click the plus icon.
So, in the first in top count give 5000, in the second get items in order by, do it in descending order and in top count give rest of the items.
[My bad there is not skip option in this, it was there in list rows in a table for onedrive excel.]

Was this reply helpful? Yes No
hovanviet1292 6 on at

Like (0)

Report
Copy link

Link copied!

Hi @Sundeep_Malik ,

I followed for guide, but the issue still occur.

Was this reply helpful? Yes No
hovanviet1292 6 on at

Like (0)

Report
Copy link

Link copied!

Can someone help me?

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report
Copy link

Link copied!

@v-liwei-msftIs it fine, me tagging you in so many posts?
@Pstork1

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Sundeep_Malik @hovanviet1292

I think your method is great!
I'm just adding a little addition to your method (your method is probably the most perfect).
You can display the ID column in the SharePoint list and turn on the count (so you can see how many items are in the list to avoid getting duplicates in two get items in parallel.)
Also, as Sundeep_Malik said, upgrading your license is a great way too!

Best Regards,
Levi

Was this reply helpful? Yes No
Pstork1 69,018 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Apply to each loops are limited to a maximum of 5,000 items if you are on the Office 365 seeded license or Power Automate free. The per user license allows loops of up to 100,000 items. If you need to process more than 5,000 items in a loop you should upgrade to a paid license. This article outlines the limits.

Limits and configuration - Power Automate | Microsoft Learn

Was this reply helpful? Yes No