Is there anyway to reduce the execution time of the flow that has variable within a loop?

[aakashmarasini]

Hello everyone,
I am trying to extract the data from web API and copy that into the excel Tables. It is taking more than 30 minutes.
Basically, there are multiple loops in my flow and I have used 'Set' variable within a loop by keeping its value as "null". So that, data can be appended within the internal loop only. 
Similarly, using the concurrency and degree of parallelism, data is appended abnormally. I think this cannot be used within the loop that has Variables.

So, How can I reduce the execution time of the flow? Can we use compose action instead of variable in this workaround ?

Below is the part of flow. 

Thank You!
Regards,
Aakash

[jitheshk]

If you are using variables then Parallelism will create issue. Incase if the following action are not dependent you can add "Parallel branches" run the independent actions parallelly rather than running them sequentially... 

[Chriddle]

These topics can greatly speed up your flow by eliminating loops:

• Restructure/query data using xpath
• Graph API to add data to Excel

[aakashmarasini]

Thanks @jitheshk for the response. 
I cannot use the "Parallel branches" because there are many cases where one actions is dependent on another.
Best Regards,
Aakash

[aakashmarasini]

@Chriddle Thanks for the your reply.
I have gone through the documentation xpath . However, it looks like xpath will not work in my flow. I need to collect array of data under array. So, Loop is necessary.
Regards,
Aakash

[Chriddle]

Maybe you can describe what you're doing and/or show your JSON.

xpath could be a more powerful tool than it seems at first glance.

[aakashmarasini]

@Chriddle Due to the privacy, I couldn't keep the JSON. However, I tried to explain what I am doing in the flow.

Similarly, There is Excel file for each company in SharePoint. Each file has 19 product tables and data needs to be pasted on the correct table on the correct file. I have a data mapping table that is used in mapping the file name, Product Table name of the Excel file with Web API.

However, the data is pasted correctly.  
The main issue is execution time of the flow.

Thanks!

[Chriddle]

Unfortunately, this doesn't tell me the structure of your data.

Some JSON seems necessary.

[Christ0f]

One can add filter queries in the list Excel action and try to use Switch actions instead of foreach to increase performance.  Link link2