Insert Rows to Excel from Execute SQL Query flow is very slow

[alvin_wi]

Hi All,

My 1st post :), here it goes

I'm trying to insert the output of the SQL query (a single column SELECT statement) to an Excel table (1 column as well), but it took some time to finish inserting all the rows? The output is around 640 rows, and the apply to each flow took around 8 minutes to insert 500 rows - which then I cancelled.

Could you guys advise how I could optimise it or I just use the flow incorrectly?

Thank you!