cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jbrit2020
Continued Contributor
Continued Contributor

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
Super User
Super User

instead of combobox.selected

try SelectedItems

View solution in original post

3 REPLIES 3
zmansuri
Super User
Super User

instead of combobox.selected

try SelectedItems

jbrit2020
Continued Contributor
Continued Contributor

@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. 

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

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

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,426)