Combo box Filter, Sort and Seach

[Alison1]

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

[VJR]

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)

[Alison1]

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)

[Gochix · Accepted solution]

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]

Hi @Gochix yes this worked, thank you.