Gallery filter if blank

(0) Share

Report

Posted on by MostafaGamal

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)

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@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)

Was this reply helpful? Yes No