1 min read

Announcing the AAD User Virtual Table – Find and add any AAD user to your records.

We are happy to announce support for an Azure Active Directory – AAD  User virtual table for Dataverse. The AAD User table makes it easy to retrieve any user in your organization’s Azure Active Directory – not just users who have a Dataverse license assigned to them.  You can also retrieve details like job title, email, phone number and more.

The new AAD user table is available automatically with no additional configuration required.

AAD User is different from the User table in Dataverse. The User table only displays users who have a Dataverse license assigned to them. AAD User will show anyone in the AAD User address book.  Note that the AAD User table is read only.

Here is a brief video about the new table, also information is available below.

The AAD User virtual table can be found in your Tables view by selecting “All”.

The table itself includes many valuable columns of information about each user.

AAD User can be used as a Lookup column in an existing table, which will immediately provide a list of all AAD Users.

Screenshot of a Power App displaying the AAD User Dropdown Contents

With some additional formulas you can also use the selected dropdown value to populate additional information from the AAD User table into your forms

A screenshot showing how to build a formula to populate a text field with a job title based on the selection of a user in the AAD User lookup.

For example, the AAD User Lookup dropdown is DataCardValue5.  In the text field named Job Title the Default value is formula:

DataCardValue5.selected.’Job Title’

When the app is run, selecting a user from the dropdown will automatically retrieve the job title from the AAD User table and insert it into the text field.

Screenshot of a Power App displaying a populated Job Title value that was retrieved using a formula on the job title field.
Note: At this time, AAD User will not retrieve groups or provide expanded information such as manager. These are potential future enhancements to the table.

Important: AAD User is not currently available for Automate. This is planned for a future release.

API information for the AAD User table can be found here.