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.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.