Unanswered

Inserting multiple rows in SQL Server table

(0) Share

Report

Posted on by 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.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

CU-18081211-6 9,270 Moderator on at

Like (1)

Report
Copy link

Link copied!

@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 !

Was this reply helpful? Yes No
ysharma 19 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Hvus 33 on at

Like (0)

Report
Copy link

Link copied!

Hi!
Did you try to use bulk insert instead insert into? This is the fast method to masive insertion.
Hope this help.

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
takolota1 4,978 Moderator on at

Like (1)

Report
Copy link

Link copied!

Anyone looking to do something similar, you can try this batch SQL CRUD template:

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/SQL-Batch-Create-Read-Update-and-Delete/td-p/1715338

Was this reply helpful? Yes No
Sainadh 7 on at

Like (0)

Report
Copy link

Link copied!

Hello YSharma,

Did you figured it out how to load multiple rows in sql server from Power Automate ?

Thank you

Was this reply helpful? Yes No