cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JackP
Frequent Visitor

Flow is slowing down extremely

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
VictorIvanidze
Community Champion
Community Champion

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

--------------------------------------------------------------------------------------
Contact me if you are interested in custom Power Automate development.

View solution in original post

2 REPLIES 2
VictorIvanidze
Community Champion
Community Champion

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

--------------------------------------------------------------------------------------
Contact me if you are interested in custom Power Automate development.

Hi,

 

Thanks a lot for your advise. 

This solution is brilliant. 🙂 

 

 

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,683)