Share via

Dynamic AZ Active Directory connection for SQL in Logic Apps

Julian Gallego 20 Reputation points
2023-11-07T22:58:03.2466667+00:00

Hi,

Is it possible to establish a dynamic connection with Azure Active Directory in Logic Apps to connect to a SQL database?

User's image

User's image

In order to save the connection I need to click "Sign in" and get authentication with a user. Is it possible that the connection window will just opens up when some one call the Logic app? The idea is not to use a predefined Azure AD user.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,996 questions
Accepted answer
  1. Konstantinos Passadis 17,456 Reputation points MVP
    2023-11-08T00:03:30.7066667+00:00

    Hello @Julian Gallego !

    Welcome to Microsoft QnA!

    To answer your Question , no this is not supported

    But

    You could change to Power Automate that has options to automate authentication somehow or mimic user actions

    Have a look here for other possible solutions

    https://learn.microsoft.com/en-us/azure/connectors/connectors-create-api-sqlazure?tabs=consumption

    I hope this helps!

    Kindly mark the answer as Accepted and Upvote in case it helped!

    Regards

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest