Dataverse/Azure: add AAD users to systemusers

When you enroll in the Microsoft 365 Developer Program (read my experience here), you get access to portal.azure.com where you have only one user - yourself.

You would want to add more users to develop your projects.

Azure Active Directory (located at portal.azure.com) is currently called Microsoft Entra ID. I still use abreviation AAD here.

Prerequisite here is that you shall have active environment with Dataverse on make.powerapps.com, see this post on how to make it.

In this post I give a brief overview of how to:
1) Create users in bulk
2) Add Microsoft Power Apps for Developer licence to users
2) Add users to the Dataverse systemusers table to use in your Power Pages portal with Dataverse

Create users in bulk

Go to mockaroo.com and generate a number of user with first, last and full names, and job title at a minimum. I do 10 users.

Go to portal.azure.com -> Users -> Bulk operations -> Bulk create -> Download csv template.

Copy the data from the mockaroo file into the template -> save as .csv (make sure that you have comma as a separator as some languages use semicolon that is not valid. Make sure that you have a

That is the raw csv that you will import:

version:v1.0
Name [displayName] Required,User name [userPrincipalName] Required,Initial password [passwordProfile] Required,Block sign in (Yes/No) [accountEnabled] Required,First name [givenName],Last name [surname],Job title [jobTitle],Department [department],Usage location [usageLocation],Street address [streetAddress],State or province [state],Country or region [country],Office [physicalDeliveryOfficeName],City [city],ZIP or postal code [postalCode],Office phone [telephoneNumber],Mobile phone [mobile]
Essa Stuckes,[e-mail],your-email.onmicrosoft.com,No,Essa,Stuckes,Accounting Assistant I,,,,,,,,,,
Eugenius Wixey,[e-mail],your-email.onmicrosoft.com,No,Eugenius,Wixey,VP Accounting,,,,,,,,,,
Pierce Wandtke,[e-mail],your-email.onmicrosoft.com,No,Pierce,Wandtke,Research Associate,,,,,,,,,,
Jemimah Jope,[e-mail],your-email.onmicrosoft.com,No,Jemimah,Jope,Mechanical Systems Engineer,,,,,,,,,,
Rasia Beazley,[e-mail],your-email.onmicrosoft.com,No,Rasia,Beazley,Compensation Analyst,,,,,,,,,,
Parsifal Ogles,[e-mail],your-email.onmicrosoft.com,No,Parsifal,Ogles,Paralegal,,,,,,,,,,
Gwenny Dinsell,[e-mail],your-email.onmicrosoft.com,No,Gwenny,Dinsell,Physical Therapy Assistant,,,,,,,,,,
Silva McGing,[e-mail],your-email.onmicrosoft.com,No,Silva,McGing,Technical Writer,,,,,,,,,,
Henderson Kender,[e-mail],your-email.onmicrosoft.com,No,Henderson,Kender,VP Quality Control,,,,,,,,,,
Bing Whatman,[e-mail],your-email.onmicrosoft.com,No,Bing,Whatman,Information Systems Manager,,,,,,,,,,

On portal.azure.com -> Users -> Bulk operations -> Bulk create -> Upload your csv file (may take minutes to import).

After the operation is complete, you will get 11 users in total including yourself.

Add Microsoft Power Apps for Developer licence

To use AAD users in Dataverse, they would need to have Microsoft Power Apps for Developer licence. The Developer Program provides such licences for 9999 users + 1 already enabled on your user.

Go to admin.microsoft.com -> Billing -> Licences -> Microsoft Power Apps for Developer -> Assign licences -> add users (max 20) and click Assign.

Add users to Users (systemusers) table

User table is located here: make.powerapps.com -> Tables -> Users (systemuser).

After the above operations are done, the user will not automatically appear in the Dataverse Users table. You will not be able to add users to Dataverse Teams until they are present in the Users table.

We will you use Power Automate flow to add all new users to the Users table.

Go to make.powerapps.com -> Flows -> New flow -> Instant cloud flow -> name it -> select Manually trigger a flow -> then:

1) click New step -> find Search for users (V2) -> in Is search term required select No.

This step will load all users from your Azure tenant.

2) click New step -> find Apply to each -> in Select an output from previous steps type expression outputs('Search_for_users_(V2)')?['body/value']

This will iterate all 11 user objects.

3) Inside Apply to each click Add an action -> find Force Sync user -> select your environment -> in ObjectId select User id.

That's how it shall look like:

Now you can save and run your flow. As a result all users with added licence will appear in the Users table for your further needs.

Note that users which are not active in AAD or lack Microsoft Power Apps for Developer licence will fail in the Power Automate step Apply to each, but it will not prevent the active users to be added.