Inserting multiple rows in SQL Server table

[ysharma]

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.

Thank you.

[gabibalaban]

@ysharma ,

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 !

[ysharma]

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.

[Hvus]

Hi!

Did you try to use bulk insert instead insert into?  This is the fast method to masive insertion.

Hope this help.

[gabibalaban]

@ysharma ,

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.