cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nakhandu
New Member

How to connect MS Flow with SQL Server Table?

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

Hi @nakhandu ,

 

You could use the SQL server Connector in microsoft flow.

1.png

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.

View solution in original post

2 REPLIES 2
RezaDorrani
Dual Super User II
Dual Super User II

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
Community Support
Community Support

Hi @nakhandu ,

 

You could use the SQL server Connector in microsoft flow.

1.png

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.

View solution in original post

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Automate User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (52,170)