Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Copying data from one server to another table in sql server

Hi All, 


I am new to Microsoft Flow and am looking for a solution to copy records from  Server A to another table in Server B. I have wriiten a stored procedure to fetch records from Server A. 


Please guide me how to create a flow having power app button as a trigger -> execute stored procedure action..


Need it urgently .. Thanks

Advocate I
Advocate I

I haven't had experience with this but can point you to a good resource that covers filtering and copying data pretty well: Hope it helps.

Hi @Monal,


You would need to use the Gateway. Then wihtin Flow you can use the SQL actions to copy data.


I would question though if Flow is the best tool for copying DB tables.


Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (5,954)