Announcements
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?
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/UCnGNN3hdlKBOr6PXotskNLABlog : https://microsoftcrmtechie.blogspot.com
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?
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 additional info, Eric. Much appreciated.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 414
Valantis 408
timl 339 Super User 2026 Season 1
