Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Lookup a person or group in CDS entity


In a sharepoint List, you can add a column which can lookup a "perosn or group' and hence user won't have to enter the full alias.

I want to know if a similar thing is possible with the entity created in CDS, Powerapps? As in is there a lookup for a person or group function that can be used for a field in CDS entity?

Community Support Team
Community Support Team

Re: Lookup a person or group in CDS entity

Hi @Mod_admin,


There is no person or group type under Common Data Service, but we could add a Lookup type field under Common Data Service entity.

Build a relationship between entities

After a relationship has been configured, a new lookup field would be added automatically.

Which then we could take use of.





Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Level: Powered On

Re: Lookup a person or group in CDS entity

Hi @v-micsh-msft,

Thanks for the reply. Could you elaborate a bit more on that?

What I want is that the user can lookup all the employees of that organization which are on Office 365 platform. For example, there is a form in which there is a field called "Meeting With: ". As soon as the user types writing the name it should return results of the matching names from which the user can choose accordingly.

Level: Powered On

Re: Lookup a person or group in CDS entity


Screenshot (37).pngI have added the relationship. But I want to display 2 fields in the dropdown. I have added the fields in the default lookup field of the related entity yet it's not showing the 2nd field, only the primary key is being shown.

What shall I do? 

Level: Powered On

Re: Lookup a person or group in CDS entity


Were you able of creating a field to lookup a person?

I'm also working with CDS entity and I need that field, but I don't want to create an entity with names of employees to relate them with the app.

Helpful resources


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Power Platform World Tour

Coming to a city near you


PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Join PowerApps User Group!!

Connect, share, and learn with your peers year-round


Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 67 members 4,518 guests
Please welcome our newest community members: