Hi,
I am trying to filter a gallery view based on a Dataverse choices column.
My choices column is based on a status, and I would like to add an option of "ALL CANDIDATES" to the dropdown.
Following some Youtube videos I have set a ClearCollect in the OnVisible property as follows:
ClearCollect(collCandidateStatus, {Result: "ALL CANDIDATES"});
Collect(collCandidateStatus, Distinct(Candidates, 'Candidate Status'))
I have then set my drop down Items property to
and the filter on my gallery to
If(drpCandidateStatus.Selected.Result = "ALL CANDIDATES", Candidates, Filter(Candidates, 'Candidate Status' =drpCandidateStatus.Selected.Value))
The issue I am having is that in the dropdown I cannot see all the options. If I set the dropdown value to value I see the choices list, if I set it to result I only the ALL CANDIDATES, the other options are not visible, but I can select them and the filtering works on the Gallery.
I am aware that they are different data types but is there a way to be able to see them all together in the dropdown.
As a side not, I tried the new dropdown from the modern controls and that shows all options, but they are shown as a set of number and not the text.
Any help would be greatly appreciated.
