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?