web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Gallery filter if blank
Power Apps
Answered

Gallery filter if blank

(0) ShareShare
ReportReport
Posted on by

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:
I have the same question (0)
  • Verified answer
    CNT Profile Picture
    10,921 Super User 2024 Season 1 on at

    @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) 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 765 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 272

Last 30 days Overall leaderboard