Answered

Populate dropdown box with a person (displayname) from a sharepoint list, adding "All" to the list

(1) Share

Report

Posted on by TS-18010022-0

I have a gallery that I am trying to filter based on some criteria from some controls. Currently working on a filter for specific person using a regular dropdown box. (not a combobox)

In the screen's OnVisible, I have:

ClearCollect(
    colAuthors,
    {Result: "All"},
    Distinct('my_sharepoint_list','Created By'.DisplayName)
)
 
The Items property for the dropdown is set to colAuthors
The dropdown is named sel_author
The Items property for the gallery:
 
If(
    IsBlank(sel_author.Selected.Value) || sel_author.Selected.Result = "All",
    'my_sharepoint_list',
    Filter('my_sharepoint_list',Author.DisplayName = sel_author.Selected.Value)
)
 
When playing the app, the items populating the dropdown box are all 4 digit numbers instead of the string values I would expect. Functionally it all works. Can someone help me understand what I'm doing or not doing to get these numbers in my combobox instead of the actual displayname values with the "All" at the top? This is my first attempt at building a canvas app, so yes, the ClearCollect() idea above came from gpt, which has not been particularly helpful in troubleshooting this.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 154,492 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @TS-18010022-0

Firstly the output from Distinct is Value, not Result - you can also ditch the collection and make the Items of sel_author
Table( {Value: "All"}, Distinct( 'my_sharepoint_list', 'Created By'.DisplayName ) )

Then the Items of the Gallery
Filter( 'my_sharepoint_list', sel_author.Selected.Value = "All" || Author.DisplayName = sel_author.Selected.Value )

Also if that is a Modern Combo Box and it still does not work, try this on a Classic item.

Please click 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.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee

Was this reply helpful? Yes No
TS-18010022-0 4 on at

Like (0)

Report
Copy link

Link copied!

Wow. Thank you Warren. That not only gets it working, it simplifies it a great deal.

Was this reply helpful? Yes No