Re: Flow Taking hours - Sharepoint list to excel template.
@Jcurtis16 Sorry for the delay in getting back to you - been in workshops the last couple of weeks.
There are a few options that could help:
- Setting Concurrency on your Apply to each so it runs in parallel (not sequentially).
- Splitting out multiple Apply to each actions into Parallel Branches (a bit more complicated using skip and take).
- Using an Office Script including defining the Table, etc.
- Using the Graph API (requires you to have access to use Premium Connectors).
The 4th option (using the Graph API) is definitely the quickest in my opinion. But not available unless you have access to Premium Connectors. It also uses just a few billable actions as appose to 800 (each Add item in the loop).
The 3rd option would be another good option in terms of efficiency.
Below shows the 1st option, using Concurrency on the Apply to each that adds 800 items to my Excel Table. The only caveat is that the items won't be added to your Excel Table in the same order you have them in SharePoint.
Without Concurrency it took approx. 19 minutes.
With Concurrency set to a Degree of Parallelism of 10, it took approx. 8 minutes.
With Concurrency set to a Degree of Parallelism of 20, it took approx. 8 minutes.
----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.
