Forum Discussion
Alexread1765
Feb 15, 2022Copper Contributor
Help! Filter Gallery with Multiple Combo Box
Hi All, I have created a gallery and multiple Combo boxes which pull data from SharePoint. I have created a filter, but when any Combo Box is blank, it doesn't work. Do you know how to amend ...
SpoTech
Oct 04, 2022Copper Contributor
Try this approach -
Filter(
'env-List-ContactsSample',
(
(
(Topic = ComboBox5.Selected.Result || IsBlank(ComboBox5.Selected.Result)) &&
('Target Audience' = ComboBox4.Selected.Result || IsBlank(ComboBox4.Selected.Result)) &&
Category = ComboBox3.Selected.Result || IsBlank(ComboBox3.Selected.Result)) &&
(
TextInput1.Text in Title ||
TextInput1.Text in Description ||
TextInput1.Text in Topic.Value
)
)
)
)