Answered

People Picker Choices from Another List

(0) Share

Report

Posted on by RodM

193

I have a SharePoint list with a person column, that I've added certain employees to, with the list name "Advocates", the column name is "Advocate".

On a New form for "Escalations", I'd like to have a people picker that allows me to choose from the employee names on the "Advocates" list.

The default formula for the people picker on Escalations is:

Items = Choices([@'Escalations'].AssignedTo)

What would I change this formula to? I've tried the formula below with no success:

Items = Distinct('Advocates',Advocate.DisplayName)

I'd like to just populate this list with the items already added to the Advocate list under the Advocate title.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,125 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @RodM ,

Try this

Distinct( AddColumns( 'Advocates', "AdName" Advocate.DisplayName ), AdName )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
RodM 193 on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you! Small typo fixed:

Distinct( AddColumns( 'Advocates', "AdName", Advocate.DisplayName ), AdName )

Was this reply helpful? Yes No
RodM 193 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz ,

Although this has technically worked to populate the combobox, when I submit the form, nothing is there. What do you think I'm missing here?

This source data is a person column, and I'm attempting to submit it into a form field that is also expecting a person.

Was this reply helpful? Yes No
WarrenBelz 156,125 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@RodM ,

One of the (many) reasons I do not use complex field types such as person/lookup etc. You only have one element of the field when you use a Distinct filter on the Items, so you need to get the rest back, particularly the email. This needs to be in the Update of the Data Card and you could consider the Office365 connector using the name you just selected to get the email back.

Was this reply helpful? Yes No