How to create a column I want in AAD user dataverse table?

(0) Share

Report

Posted on by Bubufun

I want to create a column in AAD user dataverse table

like this :

But then it will happen like "Something went wrong"

I want to create a custom AAD User table that can connect Azure AD

How can I do this?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (3)

Report

Hi @Bubufun ,

This is a virtual table with the data stored in Azure Active Directory, you will not be able to add columns to this table like you would do with other tables as the data is not actually stored in Dataverse. You could created a custom table, something like AADUser_Extend that lives in Dataverse that contains a lookup column related to the AADUser virtual table to create this relationship. This would allow you to add additional fields / extend as needed.

Was this reply helpful? Yes No
humblpirate 71 on at

Like (0)

Report
@dpoggemann I'm trying to do this same thing and I'm stuck at the next steps.

I created a table called "CurrentUsers" and I essentially want to populate the entire table from the AAD users table. I created a column also called "Current User" and set the data type as "lookup". That column now allows me to search for a name.

Questions:
is there a way to cause all rows of the dataverse table to populate here? (rather than me having to type out the names of all my users first) I've tried to import data, but the AAD user table isn't an option.
once I have one lookup column, how to add additional columns that pull in data from other columns in the related table?

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @humblpirate ,

Take a look at the solution provided in this post: Solved: Office365Users to synch to a dataverse table - Power Platform Community (microsoft.com) as I think it might be very helpful.

Was this reply helpful? Yes No
RoyMitrany 10 on at

Like (0)

Report

Hi Drew,
I also have a use case where I need to extend the AADUser table. As you suggested, I created a custom table called AADUser_Extend, with lookup column to AADUser. I have (so far) two problems:
1. There is no 1:1 mapping in Dataverse. So I accidently add multiple records to the same AAD user, and there is no way to indicate this multiplicity
2. When I add a lookup from a third table to the extended table, I can't use the AADUser name as lookup. It forces my users to manually define Name value to the extended table.
Any suggestions?
Thanks,
Roy

Was this reply helpful? Yes No
MarioRing 541 Super User 2024 Season 1 on at

Like (0)

Report

AAD Users is a virtual table and has its limitations. I believe you want to store some information about employees of your organization in the Dataverse with the possibility to extend this data with some additional fields.

I suggest you not rely on this AAD User virtual table but create a new table by importing the previously exported user data from Azure Active Directory. This may be a good starting point.

The users will be created and updated in time and (as far as I know) unfortunately, it is not possible to use these events as triggers for executing a Power Automate flow (in order to update the related data in Dataverse). But maybe you have another business process related to onboarding or exiting the employee where you can attach this update? You may update the relevant procedure.
You can also periodically update the custom table with exported data from AAD.

Another hint - if all of the users you want to process in your app are also the users of Datavers/Power App you can use Dataverse's system User table which is out-of-the-box connected to the Active Directory itself.

Was this reply helpful? Yes No