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.