web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : Oltd/rszTqTUzYnlXjujSy
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / DataVerse (Teams): Cre...
Power Apps - Microsoft Dataverse
Unanswered

DataVerse (Teams): Creating an Employee Table

Like (0) ShareShare
ReportReport
Posted on 14 Apr 2022 15:04:18 by StuartSmith 220

Totally new to DataVerse and now researching and watching lots of Videos, but know you guys & girls are very knowledgeable & therefore asking my question here.

 

I plan to create an off-boarding "Business Process Flow" and want to create an "Employee" table for all leavers, but instead of manually entering all the user details already stored in AD/Azura AD, I was hoping I could simply create the columns such as "UserID", Email Address", "Manager", etc. and upon entering the UserID it populated all the other columns for AD/AD Azure/O365 Users, etc.

Is this possible and if so, how?

Thanks in advance.

Categories:
Microsoft Dataverse
I have the same question (0)
  • EricRegnier Profile Picture
    EricRegnier 8,716 Most Valuable Professional on 14 Apr 2022 at 21:12:58
    Re: DataVerse (Teams): Creating an Employee Table

    Hi @StuartSmith ,

    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.

    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!

  • EricRegnier Profile Picture
    EricRegnier 8,716 Most Valuable Professional on 14 Apr 2022 at 22:30:23
    Re: DataVerse (Teams): Creating an Employee Table

    Hi @StuartSmith, also Microsoft has just released the AAD User virtual table in Dataverse which could be a great option! More info:

    https://powerusers.microsoft.com/t5/Microsoft-Dataverse/New-table-in-Dataverse-AADUser/m-p/1545680

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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 714 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 419 Super User 2025 Season 2

#3
developerAJ Profile Picture

developerAJ 243

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans