I have a solution which includes a Power App, a Power Flow and a Connection Reference to Azure SQL using a Service Principal account. This all runs successfully when I test it under my login.
BUT when I share the application within other users they are prompted to enter in the Service Principal login details (tenant Id, client secret etc).
I have tried numerous things including making the other user a co-owner of the application and flow. In addition, all of the documentation I can find on Service Principals shows examples for connecting to Dataverse or Azure SQL only through powershell. I cannot seem to find anything with the exact same architecture I have.
Is it even possible to use a Service Principal connection to Azure SQL in a Power Automate Flow within a Power App without the user having to enter in further credentials?
The error message the other user got was:
{
"status": 400,
"message": "Invalid connection settings\r\n inner exception: Not a valid data source.\r\nclientRequestId: xxxxxx",
"error": {
"message": "Invalid connection settings\r\n inner exception: Not a valid data source."
},
"source": "sql-xxxxx-001.p.azurewebsites.net"
}
Invalid connection settings
inner exception: Not a valid data source.
clientRequestId: xxxxxx
