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 ...
ganeshsanap
Oct 05, 2022MVP
Alexread1765 Use this formula in items property of gallery control:
Filter(
'SharePoint FAQ',
TextInput1.Text in Title || TextInput1.Text in Description || TextInput1.Text in Topic.Value,
IsEmpty(ComboBox5.SelectedItems.Value) || IsBlank(ComboBox5.SelectedItems.Value) || Topic.Value in ComboBox5.SelectedItems.Value,
IsEmpty(ComboBox4.SelectedItems.Value) || IsBlank(ComboBox4.SelectedItems.Value) || 'Target Audiance'.Value in ComboBox4.SelectedItems.Value,
IsEmpty(ComboBox2.SelectedItems.Value) || IsBlank(ComboBox2.SelectedItems.Value) || Category.Value in ComboBox2.SelectedItems.Value,
IsEmpty(ComboBox3.SelectedItems.Value) || IsBlank(ComboBox3.SelectedItems.Value) || 'SP Version'.Value in ComboBox3.SelectedItems.Value
)
Documentation: Filter, Search, and LookUp functions in Power Apps
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.