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 foun