You’re offline. This is a read only version of the page.
51
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?
Thanks for the additional info, Eric. Much appreciated.
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-Power-Platform-and/ba-p/850804
Hope this helps!
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?
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
#1
stampcoin
17
#2
ankit_singhal
11
Super User 2025 Season 1
#3
mmbr1606
9
Super User 2025 Season 1
Share
Report
All responses (
Answers (
