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))
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!
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!
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)
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)
WarrenBelz
89
Most Valuable Professional
MS.Ragavendar
60
stampcoin
48