cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
StuartSmith
Resolver I
Resolver I

DataVerse (Teams): Creating an Employee Table

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.

2 REPLIES 2
EricRegnier
Super User
Super User

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
Super User
Super User

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (6,653)