Power Platform Community Forum Thread Details

I am trying to get a combo box that may have between 0 and several selections to filter a gallery. The combo box is connected to a SharePoint choice field (radio).

The Items property in the combo box is this:

Distinct('SP List', ChoiceFieldName.Value).Result

DisplayFields and SearchFields are each ["Result"]

The Items property in my Gallery is this:

Filter('SP List', If(CountRows(ComboBox1.SelectedItems) > 0, ChoiceFieldName.Value in ShowColumns(ComboBox1.SelectedItems,"Result"), true))

There is no issue with the formula (except for a delegation warning). The combo box gets items as expected. However no filtering occurs on the list; it just shows all items regardless of what is in the combo box. Any resources or suggestions?

Categories:

Building Power Apps