Person Field from other list isn't showing on the list when I'm trying to connect to this list

[amoshe2]

Hi,

I'm trying to pull up an Employee name from other list(PDP EMPLOYEE) - the field is a Person field 

I have created a drop down field and pick on the item the relevant list (added DB to new list)

for some reason I can't find the Employee field from the other list, I can see all the rest but not the Person field (see attached pic)

when i put on the items the "list name.Employee" - I'm getting the below error - blue underline

Appreciate the help

Almog

[BCBuizer]

Hi @amoshe2 ,

A dropdown control will only show text from a single column. Since the Employee column is a Person/Group type, it contains records (multiple "sub columns"). For the dropdown to work, you need to select one of those "sub columns", for instance: 'PDP Employees'.Employee.Email.

If you wish to retain the person data type, instead of using a dropdown, use a combobox:

https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/controls/control-combo-box

[amoshe2]

OK I have change my field to Combo Box and write at the items 'PDP EMPLOYEE'.Employee 

but it give me an empty list 

what should I put on the Items that it will bring the employee name from Person field on the other list

[RandyHayes]

@amoshe2 

Change your Items property to: 

   Choices('PDP Employee'.Employee)

I hope this is helpful for you.

[amoshe2]

Hi Randy,

I already tried this out but I'm getting a weird list not relevant for this field (not sure what is it)

I have under the employee drop down just 2 names

[phipps0218]

That looks like your Choices is pulling from your Active Directory. How has the choice been setup?

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

[amoshe2]

Yes it look like as connect to other directory, what you mean by saying "How has the choice been setup"?

[RandyHayes]

@amoshe2 

It's not a choice column, it is a Person column.

Your image of the results for the person column looks correct, what is it that you are questioning (i.e. what is not relevant)? 

[amoshe2]

I'm trying to get the Employee name(Person field) list into my new SP list

Didn't understand why I can't pull the employee name into my list 

Is there an option to have Favorites on Person field? I want to have ~15 people that will be populated under this dropdown/combobox field