Flow is slowing down extremely

[JackP]

Hi,

I built the flow that exports test points for selected projects in DevOps. 

I have 4 projects and for each of them there are 3 http request sent:

1 PROJECT

Get test plans -> get test suites -> HTTP request  get test points (~600 items) -> parse json -> (apply to each pharsed item) append each item to array -> create CSV table from array -> create CSV file -> send CSV file->reset array

2 PROJECT

Get test plans  -> get test suites -> HTTP request get test points (~500 items) -> parse json -> (apply to each pharsed item)(append each item to array -> create CSV table from array -> create CSV file -> send CSV file->reset array

3 PROJECT

Get test plans -> get test suites -> HTTP request get test points (~500 items) -> parse json -> (apply to each pharsed item) append each item to array -> create CSV table from array -> create CSV file -> send CSV file->reset array

4 PROJECT

Get test plans -> get test suites -> HTTP request  get test points (~2400 items) -> parse json ->(apply to each pharsed item) append each item to array -> create CSV table from array -> create CSV file -> send CSV file->reset array

Flow needs around 45 min in total for first 3 projects.

Unfortunately flow is slowing down extremely when reaches 4th project. It hangs 3-4 hours without completing the loop.

Data structure is the same as for project 1,2,3. The only difference is the number of items that needs to be appended to array. 

What can be the reason of that? 

Thank you in advance for help. 

[VictorIvanidze · Accepted solution]

Have a look at this: https://powerusers.microsoft.com/t5/Using-Flows/Slow-running-of-Apply-to-each-only-joining-data/m-p/...

[JackP]

Hi,

Thanks a lot for your advise. 

This solution is brilliant. 🙂