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,927 questions
{count} votes

Accepted answer
  1. Konstantinos Passadis 17,376 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 No comments

0 additional answers

Sort by: Most helpful