
Announcements
Hi all,
I use combo box to filter gallery and based on the choice by the user the data displayed in the Gallery
I want the gallery to show all the result if the user doesn't choose anything in the combo box
How to do that? i use the function in the gallery as showing below
Filter('Action Plan Add', status <> "Done", 'Planned Date'
>= StartDate.SelectedDate&& 'Planned Date' <= EndDate.SelectedDate , Line = ComboBox1.Selected.Result,'Department '=Gallery4.Selected.Department)
@MostafaGamal Try this,
Filter('Action Plan Add', status <> "Done", 'Planned Date'
>= StartDate.SelectedDate && 'Planned Date' <= EndDate.SelectedDate,
If(CountRows(ComboBox1.SelectedItems)=0,true,Line = ComboBox1.Selected.Result),'Department '=Gallery4.Selected.Department)