Timeline for PowerApps allow guest users to connect to Azure SQL database with AAD integrated feature
Current License: CC BY-SA 4.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 21, 2021 at 12:08 | history | bounty ended | Kresimir L. | ||
| Mar 18, 2021 at 16:08 | comment | added | Kresimir L. | @Tiny-wa, My accounts are all work accounts (Office 365). | |
| Mar 18, 2021 at 9:18 | comment | added | Tiny Wang | @KresimirL. Excuse me sir, do the guest accounts are work accounts? I found that my guest which could see the data is a personal account, but when I test with a work account , it can see the data. I'm now trying to find a solution. | |
| Mar 18, 2021 at 9:15 | comment | added | Tiny Wang | @milivojeviCH I've tried to create a group and add users into it, then set this group as the admin of sql server instance, then the users in it can all access the table, even without executing create/grant sql in the database, but this suitable for member accounts and guest account which is a personal account. | |
| Mar 18, 2021 at 8:34 | comment | added | Kresimir L. | @milivojeviCH that was my first intention to use AAD group, but again, guest users couldn't see the data, even though they had direct access to SQL. | |
| Mar 17, 2021 at 15:58 | history | edited | Tiny Wang | CC BY-SA 4.0 |
added 1038 characters in body
|
| Mar 17, 2021 at 15:34 | comment | added | Tiny Wang | @KresimirL. I'm not an expert in powerapp indeed, I'll share my creating details. | |
| Mar 17, 2021 at 15:21 | comment | added | Tiny Wang | @milivojeviCH I haven't try that yet, it sounds like to be a good idea :) | |
| Mar 17, 2021 at 14:47 | comment | added | milivojeviCH | Did you try to create an AAD group, add the internal user and the guest into the group and authorise the group itself to be a reader on the SQL Server side? | |
| Mar 17, 2021 at 10:17 | comment | added | Kresimir L. | Hi @Tiny-wa , thank you for your comprehensive answer! Tried everything as you stated in your reply. Still, the guest user cannot see the data in App. Could it be due to the PowerApps environment? I'm using a sandbox environment, not the default one. If you could share more info about your PowerApps or SQL setup that could be relevant in making this work? For my AD server there is a master Admin with who I've created the database. Only later have I added AD Integrated Admin so that I could create an external user. | |
| Mar 17, 2021 at 8:22 | history | edited | Tiny Wang | CC BY-SA 4.0 |
edited body
|
| Mar 17, 2021 at 8:16 | history | edited | Tiny Wang | CC BY-SA 4.0 |
added 1869 characters in body
|
| Mar 17, 2021 at 7:52 | history | answered | Tiny Wang | CC BY-SA 4.0 |