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
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:
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
Change your Items property to:
I hope this is helpful for you.
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
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.
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)?
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
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!