5
Hi,
i have a problem with Power Automate.
I want add Rows from a SQL Query to an Excel table.
It works but it is extremely slow. The SQL Query has about 600 rows so in my opinion not very much.
Can anybody tell me why it takes so much time?
Thank you for your help
Hi Alice,
thank you for your help. This is the foreach part:
But if the duration ist normal in power automate i am fine with it. I only thougt it has to be faster because if write a c# program to do this, it is much faster.
Thank you
Hi @bkienle ,
Could you please share a screenshot of the actions inside the "Apply to each"?
I think the flow takes 7 minutes to create 600 rows in the Excel table from the SQL Query is within the normal range.
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
#1
WarrenBelz
146,668
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (
