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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@amoshe2

Change your Items property to:

Choices('PDP Employee'.Employee)

I hope this is helpful for you.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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
MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yes it look like as connect to other directory, what you mean by saying "How has the choice been setup"?
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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)?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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