Answered

SQL Server Connection Issue

(0) Share

Report

Posted on by DamoC

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.

Categories:

Using connectors

I have the same question (0)

All responses (5)

Answers (1)

kierian Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello

Can you use enter custom vale and enter database name

Have a good day.

Was this reply helpful? Yes No
DamoC 34 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
DamoC 34 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

DamoC 34 on at

Like (2)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
PhilParser01 3 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No