cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fess
Helper III
Helper III

dataverse custom table person column: how to get the organization directory?

Hi,

 

In Microsoft List, I can make a person-type column that allows me to search & pick a person from the 365 active directory.

 

How do I accomplish same in a custom column in a custom table in Dataverse, please?

 

Thanks for your help!

 

EDIT: I have setup a trial dataverse environment to try out some features. I am able to add Users to this manually. I would like to add a handful of Users. They do not have trial or premium licenses. Will they get assigned trial licenses, perhaps? Any issues adding Users this way for my purpose? Thanks

3 ACCEPTED SOLUTIONS

Accepted Solutions
Mira_Ghaly
Dual Super User
Dual Super User

@fess 

Yes i think assigning trial licenses would work for this purpose and they will get added to DataVerse as users so far I can't see a drawback for this approach.

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

Hello @fess,

 

Yes, but please make sure user will have COMMON DATA SERVICE license assigned

rampprakash_0-1639307621854.png

 

if you don't want to add license but if you want to see the Respective User in Dataverse you can follow my video here for step by step Guidence.

 

https://youtu.be/k7X9e4cZSSU

 

Please mark as Answer if it is helpful and provide Kudos


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

View solution in original post

fess
Helper III
Helper III

Thanks I've added Users manually for now & used the Lookup field as advised which works fine for now. 

View solution in original post

9 REPLIES 9
Mira_Ghaly
Dual Super User
Dual Super User

@fess 

There is an OTB (out of the box) table called Users, you can create a Custom Column of Type Lookup that refers to the users table but please note that this table includes only Powerapps Licensed or Dynamics 365 Licensed users.

So it depends on your requirement and if all the Active Directory users have powerapps license.

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
rampprakash
Super User
Super User

Hello @fess,

 

As per OOB behaviour who is having proper license they will be available in Dataverse User Table.

 

If you want to use only the users available in Dataverse then create a lookup field where you are expecting.

 

If you need office directory users then Create a custom table in DataVerse environment then write Microsoft flow to FETCH data from OFFICE 365 and PUSH it to DATAVERSE by adding ADD ROW.

 

Then create a look with this custom table to access the same 

 

Let me know if you need more clarity.

 

Please mark as Answer if it is helpful and provide Kudos

 

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

Blog : https://microsoftcrmtechie.blogspot.com

fess
Helper III
Helper III

Thanks for response. I am building a prototype so not many Users have licenses so I have to pull 365 users.

 

Could you let me know the action specifically in Power Automate? I selected Office 365 connector but I don't see a way to "FETCH" all users as suggested.

 

Could you please advise the steps?

 

Thanks

Hi, please also note EDIT above in original post. Thanks.

Mira_Ghaly
Dual Super User
Dual Super User

@fess 

Yes i think assigning trial licenses would work for this purpose and they will get added to DataVerse as users so far I can't see a drawback for this approach.

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Hello @fess,

 

Yes, but please make sure user will have COMMON DATA SERVICE license assigned

rampprakash_0-1639307621854.png

 

if you don't want to add license but if you want to see the Respective User in Dataverse you can follow my video here for step by step Guidence.

 

https://youtu.be/k7X9e4cZSSU

 

Please mark as Answer if it is helpful and provide Kudos


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

fess
Helper III
Helper III

Thanks I've added Users manually for now & used the Lookup field as advised which works fine for now. 

rampprakash
Super User
Super User

Hello @fess,

 

Can you please mark the respective Solution, it will help community.

i haven't marked it as solution because like i said in my final post, the appropriate solution is to simply add users to the environment & then perform lookup as advised. 

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (5,218)