cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chiguypaul
Helper I
Helper I

How to best populate Dataverse with users from Active Directory

In SharePoint, there's a people column that references users in Azure AD/Office 365. Is there a way to have a column that can perform the same? From what I've seen, I only see users with PowerApps licenses to choose from. Any suggestions on how to best accomplish what I can do in SharePoint in Dataverse?

1 ACCEPTED SOLUTION

Accepted Solutions
EricRegnier
Super User
Super User

Hi @chiguypaul,

As @rampprakash stated, users can automatically be synced out-of-the-box (OOB) in the User (systemuser) table. Note however that by default those will only be active licensed (a valid Power Apps / D365 license) users. So not all users will be there. If you want inactive or unlicensed users to be automatically synced in Dataverse, you can import them in the User table as inactive status. This can be done with an Excel import, Power Automate, etc.

And to answer your last question, yes it's standard and the best practice. It is recommended not to recreate a User table because it comes OOB with the common data model (CDM). See tip #5 in https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Top-15-best-practices-when-configuring... 

Hope this helps!

View solution in original post

4 REPLIES 4
rampprakash
Super User
Super User

Hello @chiguypaul,

 

As per oob behaviour No, users with PowerApps license only can see in DataVerse environment in USER table.

 

If you want to use Office 365 users, Create a Table in DataVerse for storing custom User details.

 

Create a flow and Sync Office 365 Users with Custom Table.

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

chiguypaul
Helper I
Helper I

Thanks for the fast reply. Is that considered the "standard" approach that various companies are using? Any suggests for how to go about setting up a sync with the Office 365 Users table and a custom table?

EricRegnier
Super User
Super User

Hi @chiguypaul,

As @rampprakash stated, users can automatically be synced out-of-the-box (OOB) in the User (systemuser) table. Note however that by default those will only be active licensed (a valid Power Apps / D365 license) users. So not all users will be there. If you want inactive or unlicensed users to be automatically synced in Dataverse, you can import them in the User table as inactive status. This can be done with an Excel import, Power Automate, etc.

And to answer your last question, yes it's standard and the best practice. It is recommended not to recreate a User table because it comes OOB with the common data model (CDM). See tip #5 in https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Top-15-best-practices-when-configuring... 

Hope this helps!

chiguypaul
Helper I
Helper I

Thanks for the additional info, Eric. Much appreciated.

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (2,916)