cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jbrit2020
Responsive Resident
Responsive Resident

Combobox multiple selection to filter ANY selected values on gallery.

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.

1 ACCEPTED SOLUTION

Accepted Solutions
zmansuri
Community Champion
Community Champion

instead of combobox.selected

try SelectedItems

View solution in original post

3 REPLIES 3
zmansuri
Community Champion
Community Champion

instead of combobox.selected

try SelectedItems

View solution in original post

jbrit2020
Responsive Resident
Responsive Resident

@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
Community Champion
Community Champion

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

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,687)