Azure SQL DB Permission

(0) Share

Report

Posted on by Eric McKinney

173

Power Apps Team

I have a form that is writing to an Azure DB table, it works fine in my design, however when I share the app with someone it asks for an "Allow" permissions on the SQL table when opening the data source. I am not sure what permissions I should put on the Azure SQL DB, as I am typing this though I am wondering if adding Azure AD permissions to the database would do the trick.

Whats anyone else's experience working with submitting data from a form in PowerApps to Azure DB and setting up permissions?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

v-monli-msft on at

Like (0)

Report

Hi,

The sentence "It asks for an "Allow" permissions on the SQL table when opening the data source", would you please help to collect a screenshot of this for better understanding?

Regards,

Mona

Was this reply helpful? Yes No
Eric McKinney 173 on at

Like (0)

Report

Basically I don't have a way to allow. I did add the Azure AD account to the table and I can access it via SQL Management studio however from the app I the screenshot above.

Was this reply helpful? Yes No