cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jbrit2020
Super User
Super User

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

View solution in original post

@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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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.

Top Solution Authors
Top Kudoed Authors
Users online (2,797)