Apply to each - Timeout

[Anonymous]

We have a process where we have a list of O365 groups retrieved from MSGraph, and want to iterate through them to check if any of them have the displayName = "A", "B" or "C".

To iterate through this list, we have used the "Apply-to-each" action, but for reasons that I can't comprehend, it times out... Any ideas/suggestions?

The overview of the process in PowerAutomate:

0) PowerApps - The PowerAutomate process is triggered from a PowerApp

1) Custom connector - Get O365 groups through

2) Parse JSON - O365 groups

3) Compose - Create an array from O365 groups json object

4) Apply to each - For each O365 group in the array (90 groups in this case) --> THIS IS WHERE WE GET A TIMEOUT

4.1) Compose - Select the displayName from the current O365 group

4.2) Condition - IF displayName is equal to "A"

4.2.1) Append to string variable - Add the displayName to a "data" string variable

5) Respond to a PowerApp or flow - Return "data" string variable to

[VictorIvanidze]

Try to set limit of 10 groups. Will it work then?

[v-litu-msft]

Hi @Anonymous,

You could have a try that turns on the Concurrency control, set the degree of Parallelism to 50:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Didn't know about that setting, good tip! 

Unfortunately it doesn't seem to have had any effect on how much time the Apply-to-each action is taking.

[Anonymous]

To do this I used mock-up data.

With 10 items it took 2 seconds on the first attempt.

With 16 items, it timed out again...

[v-litu-msft]

Hi @Anonymous,

Could you share the screenshot of the timeout item?

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

A screenshot from the initial problem

Timeout

[v-litu-msft · Accepted solution]

Hi @Anonymous,

Ok, thank you for your screenshot, so it seems like some item will take more time to calculate, caused the "Respond to a PowerApps or Flow" action time out.

If you do not add the Apply to each action, just pass a simple data to PowerApss, will it run?

If possible, I think you should share the structure of the Apply to each, maybe the item caused time out is not different from others.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

I didn't try to send the data to PowerApps, instead we found that there is an action called "Check group membership "V2", an Azure AD action which does exactly what we were trying to do.

https://docs.microsoft.com/en-us/connectors/azuread/

We will ask the global tenant admins to enable this feature, and allow us to use this action instead. 

It should significantly simplify the whole PowerAutomate process.