Answered

Set Dropdown Value Property To 'User Object Column'.DisplayName

(1) Share

Report

Posted on by CU10091756-0

I have a legacy powerapp that tracks records assigned to users. When I built the app, I was able to hard code a dropdown fields value to be == a list of users who had been selected in the column from my data source.

It appears that new functionality limits the ability to only select viable columns for the value property from a list. This list does not include my people picker column.

How can I create a dropdown, who's values are equal to the list of user's displaynames from the column in my data source?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

WarrenBelz 154,791 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @CU10091756-0,

Your post is a bit vague in so much nothing has changed regarding the capabilities of Classic controls (Modern examples have different settings/abilities).

Taking a guess of what you are trying to do, a Classic Combo Box with the Items

Choices(SPListName.PersonFieldName)

will offer a selection of all users currently in that field in the List. If you want the entire company directory, that is more complex and this blog of mine sets out the various options.

If this is not the case, can you please provide the code you were using (in Text) and whether the control is a (I assume Classic) Combo Box or Drop-down.

Please ✅ Does this answer your question 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 a Like♥.
Visit my blog Practical Power Apps LinkedIn

2 people found this reply helpful.

Was this reply helpful? Yes No
developerAJ 4,763 on at

Like (0)

Report
Copy link

Link copied!

I would recommend using Office 365 users, as this approach provides greater control. For more details, you can refer to Warren’s blog on this topic

If this solution helped you resolve your issue, kindly mark it as accepted — it makes it easier for others to find and also closes the discussion. If you found it useful, a Like ❤️ would be greatly appreciated!

🤝 Let’s connect on LinkedIn || 📘 Explore more on my articles

Was this reply helpful? Yes No
CU10091756-0 6 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz Looks like your solution worked.

It returned the expected list of users contained in that field in the list.

How would I narrow the displayed data to just their display name? Normally it would an addendum of .DisplayName but I can't seem to figure out the correct syntax in this case.

Was this reply helpful? Yes No
Suggested answer

Arun K Rajan 25 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I hade a similar requirement to pull the user from another SharePoint list and to patch those users to another list.

First select the combobox and inside item property

put the list name then from the properties select the "Fields" and choose the SP Column name. then it will show the user name.

to save the name to other SP List below is a sample code.

Reviewer: {

Claims: "i:0#.f|membership|" & Lower(TechnicalLead.Email),

DisplayName: TechnicalLead.DisplayName,

Email: TechnicalLead.Email,

Department: Coalesce(

TechnicalLead.Department,

""

),

JobTitle: Coalesce(

TechnicalLead.JobTitle,

""

),

Picture: ""

},

If you need more help iam happy to support you.

Regards,

Arun

Was this reply helpful? Yes No
WarrenBelz 154,791 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @CU10091756-0,

For a Modern Combo Box (which you appear to be using), select Edit in the right paneland then add the DisplayName field.

Please ✅ Does this answer your question 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 a Like♥.
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No