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
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

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 (9,576)