Hello All -
I am trying to insert multiple rows into a sql server table, I see the current action is only capable of inserting one row at a time. Is there a way we can insert multiple rows into the sql server table? Please feel free to throw in any idea.
There is no action in Power Automate to insert multiple rows into SQL Table, but you can do it by using Apply to each action with the concurrency option set as you need (maximum 50) and inside Apply to each action the SQL - Insert Row (V2) action.
Hope it helps !
Hi @gabibalaban ,
Thank you so much for your response. I tried to put the "Insert row" action with in "Apply to each" and set the concurrency, but I am not sure what array to put here:
When I put body from previous step I am getting the below error, and getting the same error when I am putting id from previous table.
Thank you again for helping me out.
Based on your screen-shot, for each created item in table 1 an instance of the flow runs and creates a row in table 2.
I can't figure it out what multiple rows do you want to insert in the second table. The body property of the trigger SQL - when an item is created is an object (the columns values of the created item) , not an array, so you cannot use Apply_to_each action in this case.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.