Combo box Filter, Sort and Seach

Like (0) Share

Report

Posted on 6 Sep 2022 03:39:55 by Alison1

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

Categories:

General Questions

Using Apps Using Formulas

All responses (5)

Answers (1)

55552 669 on 20 Jun 2024 at 12:23:46

Like (0)

Report

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 119 on 06 Sep 2022 at 05:08:45

Like (0)

Report

Re: Combo box Filter, Sort and Seach

Hi @Gochix yes this worked, thank you.
Verified answer

Gochix 1,933 Super User 2025 Season 1 on 06 Sep 2022 at 05:01:00

Like (1)

Report

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 119 on 06 Sep 2022 at 04:09:13

Like (0)

Report

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 7,635 on 06 Sep 2022 at 03:59:23

Like (0)

Report

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)