Skip to main content

Notifications

Community site session details

Community site session details

Session Id : jF3p5dBsQudIs47fVe+mjK
Power Apps - Building Power Apps
Answered

Combo box Filter, Sort and Seach

Like (0) ShareShare
ReportReport
Posted on 6 Sep 2022 03:39:55 by 119

Hi community, I have a combobox of which I need to sort by alphabetical order, filter out the blanks and be able to search.  I am using the below formula and the search function has stopped working even when allow searching is swotched on.  Any ideas?  Thank you!

 

Filter(Sort('All Customers SLA Profile Volume & Revenue',Title,Ascending),!IsBlank(Title))

  • 55552 Profile Picture
    667 on 20 Jun 2024 at 12:23:46
    Re: Combo box Filter, Sort and Seach

    Wow, this solved my problem also. In fact, I had one combo box that was using Distinct, Filter and Sort together. With your method, I now have Distinct, Sort, Search, Filter, and it all works!

  • Alison1 Profile Picture
    119 on 06 Sep 2022 at 05:08:45
    Re: Combo box Filter, Sort and Seach

    Hi @Gochix yes this worked, thank you.

  • Verified answer
    Gochix Profile Picture
    1,933 Super User 2025 Season 1 on 06 Sep 2022 at 05:01:00
    Re: Combo box Filter, Sort and Seach

    Try:

     

    Sort(

           Search(

           Filter(

    ‘All Customers SLA Profile Volume & Revenue’,

    Title = Not(IsBlank(Title))),

    TextInput.Text,”Title”),

    Title,

    Ascending)

    ____________________________________________________________________________________

    Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

  • Alison1 Profile Picture
    119 on 06 Sep 2022 at 04:09:13
    Re: Combo box Filter, Sort and Seach

    Hi @VJR, thank you for your reply. Apologies, I'm not very good. I tried the below formulas, but couldn't get it to work.

     

    Sort(Filter('All Customers SLA Profile Volume & Revenue',Title,Ascending),!IsBlank(Title))

    Sort(Filter('All Customers SLA Profile Volume & Revenue',!IsBlank(Title)),Title, Ascending)

     

    I also tried ,If( Not IsBlank( Title ), True, Title) in place of !IsBlank(Title)

  • VJR Profile Picture
    7,635 on 06 Sep 2022 at 03:59:23
    Re: Combo box Filter, Sort and Seach

    Hi @Alison1 

    First use the Filter and then do its Sort.

    Eg; Sort(Filter(....

     

    In place of !IsBlank(Title) you can also try....

    ...,If( Not IsBlank( Title ), True, Title)

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 89 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 60

#3
stampcoin Profile Picture

stampcoin 48

Overall leaderboard