Combobox multiple selection to filter ANY selected values on gallery.

[jbrit2020]

Hi there, 

I need my comboboxes to filter ANY selected values on the gallery.

So for example, if I select on combobox 1 two options Blue and Brown, I want then the gallery to show any records that contain either values.

At the moment when I select more than one value on the combobox it only shows the last value selected.

SortByColumns(
    Search(
        Filter('OP.PBManageRisks',
            ((Toggle1_1.Value && Status="Closed") || (!Toggle1_1.Value && Status="Open"))&&
            (IsBlank(ComboBox1.Selected.Result) || Customer in ComboBox1.Selected.Result)&&
            (IsBlank(ComboBox1_1.Selected.Result) || Category in ComboBox1_1.Selected.Result)&&
            (IsBlank(ComboBox1_4.Selected.Result) || Sub_Category in ComboBox1_4.Selected.Result)&&
            (IsBlank(ComboBox1_3.Selected.Result) || Current_Risk_owner in ComboBox1_3.Selected.Result)&&
            (IsBlank(ComboBox1_5.Selected.Result) || Impact_category_Risk_Threat in ComboBox1_5.Selected.Result)&&
            (IsBlank(ComboBox1_6.Selected.Result) || Risk_Status in ComboBox1_6.Selected.Result)
        ),
        TextSearchBox1_8.Text, "RiskRef", "Risk_Title", "Category","Risk_Status"
    ),
    Dropdown1.Selected.Value,
    If(Toggle1.Value, Ascending, Descending)
)

Any help would be much appreciated.

[zmansuri · Accepted solution]

instead of combobox.selected

try SelectedItems

[jbrit2020]

@zmansuri thanks it worked! Embarrassingly I just found that I asked this question before here on the platform, but when searching the site I couldn't find it. 

[zmansuri]

Please click Accept as Solution so others will find the answer in the future. Thanks