Power Apps User Permissions & The AADUser Table
When I build apps for my department or enterprise, it is sometimes a challenge to sync up with co-workers, everyone is busier these days. But I need to test my apps with other user accounts. Fortunately Microsoft provides a way to meet these testing needs with the Microsoft 365 Developer Program. A huge thanks goes out to Microsoft for providing this service.
If you would like a safe environment where you can experiment. I recommend signing up for a free Microsoft 365 Developer Program
The Microsoft 365 Developer Program gives you the ability to experiment safely with the Power Platform, Dataverse, Connectors, Teams, Azure, and more. This is isolated from your company’s environment.
This environment creates 16 user accounts for you that you can manage in an isolated instance of Azure Active Directory, Power Platform Admin Center, and Dynamics 365.
These 16 accounts come in handy when testing your Power App by users who may have different permissions than you, the app creator. As a bonus you no longer have to annoy your co-workers each time you need to test your app.
Each user account added to the Azure Active Directory associated with the Microsoft 365 Developer Program account, will automatically be assigned the default Microsoft 365 E5 Developer (without Windows and Audio Conferencing) license.
For the purpose of this blog post it’s not required but if you wish to see all the licenses assigned to a user, go to Azure Active Directory Portal associated with the Microsoft 365 Developer Program account - Azure Active Directory - Users. Click on the user name, Assigned licenses link.
The following only applies if you are testing with the 16 user accounts that were created when you signed up for the Microsoft 365 Developer Program. If a co-worker is helping you test, you do not need to do either of the following.
In Microsoft Edge select Profiles -> Manage Profiles.
Add a Browser User Profile For:
- Your Microsoft 365 Developer Program account.
- One or more of the 16 User Accounts.
Or if you prefer you can open separate InPrivate browser windows for each test account.
I find User Profiles makes more sense to me when I test my Power App as a different user.
- Microsoft Learn - Get started with security roles in Dataverse
- Power Platform Documentation - Security in Microsoft Dataverse
Make sure you are logged into your Power Platform Environment with your Microsoft 365 Developer Program account.
It’s recommended to create a developer Environment. The default environment should only be used to create personal apps. The apps you will share with co-workers should be created in another Power Platform Environment.
If you have not already created a Developer Environment, click the cog wheel in the upper right of your browser window and click the Admin center link.
In the Admin center, click Environments then click the + New link.
If you wish to work with the new Pipelines feature I recommend having at least 3 Environments i.e. Dev, QA & Production
In the Developer environment,
- Create a new Power App.
- Add a Gallery Control to the Home screen.
- Name the gallery control, galAADUserPeoplePicker
- Add the AAD Users table as a Data source.
- Set galAADUserPeoplePicker Items to ‘AAD Users’
- Accept the default fields
You should now have something similar to the People Picker on the left.
Click the Share button, this opens a new window.
Add users and assign the Basic User and Service Reader Security Roles!
There is a Dataverse Search Role in the selection list, but in my tests, this does not provide the user with the permissions needed to surface information from the AADUser table.
According to the Microsoft docs, Dataverse Search is for searching Model Driven apps. I’m still looking for specific information about the Dataverse Search Role.
- Go to the Power Platform Environment Apps page.
- Select the line with the Power App but don’t open the app!
- Click the Monitor button
- Select the Connect user button
- Select a user and copy the Connected User Link
Open a new browser window.
Click the User Profile photo in the upper right if using Microsoft Edge.
Select the User Profile or create a new profile for the user you selected in the Monitor tool.
Navigate to the Connected User Link.
Join the monitor debug session
The Monitor tool can help you to determine if the connection is successful or not. It’s a good resource to help you in troubleshooting your applications.
You can assign a Security Role when you share the app, but you cannot deselect the role from the share session window. To make changes to Security Roles you will need to go the Power Platform Admin Center.
In the Power Platform Admin Center go to your environments settings then click users and select the user account you wish to make changes to. Click Manage Roles.
For instance maybe remove the Service Reader & Dataverse Search roles and assign the System Customizer role.
Open the apps url from the app details screen in a browser window as the User Profile. Sign in and accept to allow the requested permissions if necessary.
Now your user should see something similar to:
You can choose to Export and Import your solution to your company environment. You may want to consult your IT department first, they may have guidelines you should follow.
Hope this is useful!
I created a short video about this topic.