Copying data from one server to another table in sql server

[Monal]

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

[MGLovesFlow]

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.

[Pieter_Veenstra]

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.