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 / Search & Filter but ig...
Power Apps
Unanswered

Search & Filter but ignore filter if blank

(0) ShareShare
ReportReport
Posted on by 254

I'm creating an app that has a combo box which should filter a gallery, I also want to use a Search box.  I was having an issue with the gallery showing as empty if there was nothing selected in the combo box so I got around the issue by using the following in the items property of my gallery:

 

If(IsBlank(cmb_Application.Selected.Result),Test,Filter(Test,Application.Value = cmb_Application.Selected.Result))

 

The issue now is that I want to use a search box but I can't figure out where the search bit should go in the above function.  I get an error no matter when I put it.

Categories:
I have the same question (0)
  • CNT Profile Picture
    10,921 Super User 2024 Season 1 on at

    @Manc_Gurl Try this (replace names as required)

    Filter(Test,

       If(!IsBlank(cmb_Application.Selected.Result), Application.Value = cmb_Application.Selected.Result) &&

       yourSearchBox.Text in yourSearchColumn

    )

     

  • Manc_Gurl Profile Picture
    254 on at

    @CNT  Hmm, it gives me a warning about delegation, which is fine but it now shows nothing in the gallery after entering this.

    Filter(Test,

    If(!IsBlank(cmb_Application.Selected.Result), Application.Value = cmb_Application.Selected.Result) && txtSearch.Text in Description)

     

    I want the gallery to show unfiltered data (all data) unless somebody searches or selects something from the combobox

  • Verified answer
    CNT Profile Picture
    10,921 Super User 2024 Season 1 on at

    @Manc_Gurl Make a small change. If you still have issues I'll need a screenshot.

    Filter(Test,

       If(IsBlank(cmb_Application.Selected.Result), true, Application.Value = cmb_Application.Selected.Result) &&

       yourSearchBox.Text in yourSearchColumn

    )

  • Manc_Gurl Profile Picture
    254 on at

    @CNT 

    Worked like a charm! Thank you for the super duper quick response 🙂

  • CNT Profile Picture
    10,921 Super User 2024 Season 1 on at

    @Manc_Gurl Glad to help!

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 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard