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.
Solved! Go to Solution.
@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.
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.