Search
  • kriSHna

Create SQL connection in Power Automate with simple steps

Many of the times, we want to create SQL connection in Power Automate to execute SQL statements and fetch data from SQL so that we can re-utilize the same in either Power Automate or Power Apps .


We would have experienced difficulty in getting the data for the fields like SQL server details, data base details and establishing the authentication mechanism especially when we are connecting to SQL server using on-prem gateway.


To ease this I am sharing the steps that I have found over a period of time that will help in retrieving the data quickly by executing few commands.


Fetch SQL server details


To fetch the SQL server details execute the command to retrieve the information



Fetch SQL database details

To fetch the SQL database details execute the command to retrieve the information


Fetch windows domain name

To retrieve the windows domain name information we should execute few commands in command prompt


To retrieve the windows username information execute the below command in Command Prompt


Finally, you can enter the windows password to successfully create the connection from Power Automate to SQL server.


Hope these steps help you ease the process of successful authentication the next time you try to connect to SQL from Power Automate or Power Apps.


#PowerApps #Powerautomate #SQLServer #CreateConnection



27 views0 comments