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)

Sort by

v-monli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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