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.
Solved! Go to Solution.
instead of combobox.selected
try SelectedItems
@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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
User | Count |
---|---|
206 | |
97 | |
60 | |
51 | |
45 |
User | Count |
---|---|
258 | |
158 | |
85 | |
79 | |
58 |