cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AvivZa
Frequent Visitor

insert several rows to SQL table

Hi,

 

I want to insert several rows to an sql table. I saw there is an option to insert one row at a time, but in case I have several rows it takes a lot of time

 

is there a way to insert several rows/table?

 

 

thanks

1 ACCEPTED SOLUTION

Accepted Solutions
v-litu-msft
Community Support
Community Support

Hi @AvivZa,

 

You could put these rows into the array variable, then create an Apply to each action to loop through these rows, insert each of them by using the Insert row action:

Annotation 2020-05-05 132142.png

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-litu-msft
Community Support
Community Support

Hi @AvivZa,

 

You could put these rows into the array variable, then create an Apply to each action to loop through these rows, insert each of them by using the Insert row action:

Annotation 2020-05-05 132142.png

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (53,708)