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.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.