Answered

Combo box Filter, Sort and Seach

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

VJR 7,635 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
Alison1 119 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
Verified answer

Gochix 1,935 Moderator on at

Like (1)

Report

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!

Was this reply helpful? Yes No
Alison1 119 on at

Like (0)

Report

Hi @Gochix yes this worked, thank you.

Was this reply helpful? Yes No
55552 674 on at

Like (0)

Report

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!

Was this reply helpful? Yes No