How to connect MS Flow with SQL Server Table?

[nakhandu]

How can I connect MS flow to SQL Server table and use that table as the source of the flow? I have downloaded the table and uploaded the list in the sharepoint and I am using that as the source of Flow, however I want to connect flow directly to the SQL server table. 

Would really appreciate the help. 

[RezaDorrani]

Hi @nakhandu 

Use the on-premises data gateway to directly connect with SQL Server 

https://docs.microsoft.com/en-us/flow/gateway-reference

https://www.youtube.com/watch?v=qaWimcfpYhg

Tutorial

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[v-alzhan-msft · Accepted solution]

Hi @nakhandu ,

You could use the SQL server Connector in microsoft flow.

And you could refer to link below to learn more about the SQL server Connector:

https://www.mssqltips.com/sqlservertip/4918/microsoft-flow-and-sql-server-integration-example/

https://preview.flow.microsoft.com/en-us/connectors/shared_sql/sql-server/

Best regards,

Alice       

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