cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

2 REPLIES 2
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: https://docs.microsoft.com/en-us/flow/odata-filters 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

Announcements
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)