Unanswered

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 on at

Like (0)

Report

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

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

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

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

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

Was this reply helpful? Yes No