Unanswered

combobox - filter with multiple value/row

(1) Share

Report

Posted on by Test217

Hello,

I have a database with multiple columns. I use on of theses columns in a combobox to filter. My issue is that in the colunms there is sometimes more than one letter :

Instead of this I would like to have a list of 1Letter/row wich allows searching on my database and sorting the items with one and several letters.

To do this I tried to create a collection but it doesn't work :

OnStart :

ClearCollect(newletters;

Distinct(
    Split(
        Concat(table1; letters; ",");
        ",");
    Value)

)

Someone have an idea ?

Thanks in advance,

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

developingteal 392 on at

Like (1)

Report
Copy link

Link copied!

I would recommend just manually making your own collection of all the letter of the alphabet (or whatever) and then filtering by it. I think it will make it simpler for you and save you the headache of making something dynamic like you are trying.

Was this reply helpful? Yes No
Test217 12 on at

Like (1)

Report
Copy link

Link copied!

Thanks for you answear, i understand but i use letters as an example. I will replace them with key words in my application, so it had to be dynamic.

Was this reply helpful? Yes No
developingteal 392 on at

Like (1)

Report
Copy link

Link copied!

Do you have a list of keywords, or will that list be dynamic and changing?

Was this reply helpful? Yes No
Test217 12 on at

Like (1)

Report
Copy link

Link copied!

The database will not change often so I it is possible for me to make a list with single keywords for my comobox, that will fix my first issue.

But how can I sort my gallery after ? On one row of my columns there is often more than 1 keyword.

Thanks in advance

Was this reply helpful? Yes No
developingteal 392 on at

Like (1)

Report
Copy link

Link copied!

Do you want to filter by more than one keyword, you can built multiple filters by keywords. Just use a Filter(), and you can make multiple statements:

Ex:
Filter(Table, This = this, other Boolean statement, ...)

Was this reply helpful? Yes No