web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SQL Server Connection ...
Power Automate
Answered

SQL Server Connection Issue

(0) ShareShare
ReportReport
Posted on by 34

We want to send data from OneDrive excel table to SQL table using Power Automate. I have 2 databases in the data connection section of Power Automate and we are using an on-premise gateway.

In the data connection setup both databases are showing as connected , but only one database is selectable when I create the flow.

DamoC_1-1619496361787.png

 

DamoC_0-1619496212251.png

 

Categories:
I have the same question (0)
  • kierian Profile Picture
    Microsoft Employee on at

    Hello 

    Can you use enter custom vale and enter database name 

    Have a good day.

     

  • DamoC Profile Picture
    34 on at

    Thanks Kieran for your reply, much appreciated. I'll give that a go.

    Rgards Damian

  • DamoC Profile Picture
    34 on at

    Hi Kierian,

    I have been unable to setup a custom connections to an on-premise sql server instance. Are you able to direct me to instructions please.

  • Verified answer
    DamoC Profile Picture
    34 on at

    Issue Resolved. You need to select the "..." on the top right corner of the selection pane. 

    In my opinion this is not documented well. I eventually found the resolution in this forum (nice) when I typed in the word "dropdown".

     https://powerusers.microsoft.com/t5/Connecting-To-Data/SQL-server-connection-not-showing-up-in-drop-down/m-p/610656. 

    DamoC_1-1619644844095.png

     

     

     

     

  • PhilParser01 Profile Picture
    3 on at

    Thank you so much for this solution, the connections feature is so unintuitive.  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 251 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 239

#3
Expiscornovus Profile Picture

Expiscornovus 220 Most Valuable Professional

Last 30 days Overall leaderboard