Answered

Issue with filtering gallery in combobox Choices from MS List

(1) Share

Report

Posted on by Kyota

Hi there,

I'm having the issue where if I choose multiple tags inside the combobox it doesn't filter it properly as in it filters only the newest added tag I've choosen and if I manually remove the tags from the combobox, nothing shows anymore until i use the "reset" button I've added to it.

Those are the tags I'm using inside MS List.

The issue wherein it only shows the newest added choice I've put in.

When I remove those tags:

and the code I'm using for the gallery:

Filter(
 'Prompts';
 TextSearchBox1.Text in Aufgabe || TextSearchBox1.Text in Prompt;
 If(
 IsBlank(ComboBox2.SelectedItems);
 true;
 ComboBox2.Selected in Kategorie
 )
)

the Combobox2:

Choices([@'Prompts'].Kategorie)

The main goal was to be able to use multiple choices inside the combobox and it'd output every item from that list that contains those choices.

Do you have any tips?

Thanks.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

PowerNuggets 360 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Kyota

try this
ComboBox.Items = Choices(Prompts.MyChoices)

and your if statement
IF
IsBlank(ComboBox2.SelectedItems.Result) || IsEmpty(ComboBox2.SelectedItems) || ComboBox2.SelectedItems.Value in MyChoices.Value

_____________________________________________________________________________________
Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.

MD
Kyota 9 on at

Like
a
(0)

Report
Copy link

Link copied!

hi, @PowerNuggets

For "ComboBox.Items = Choices(Prompts.MyChoices)" i felt free and adjusted it to follows, since this didn't work that way but it still gave me one error and that's for the "=": 'some types are incompatible for comparison. These types cannot be compared: Table, Table.'

ComboBox2.SelectedItems = Choices('Prompts'.Kategorie)

as for the if statement
IsBlank, isEmpty and has invalid arguments and it received 1 argument and expected was 2 or more.
For the last "ComboBox2.SelectedItems.Value in Kategorie.Value" the name 'Value' is invalid.
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Kyota,

To filter Gallery based on multi select tags, please modify as below:

If( IsEmpty(ComboBox2.SelectedItems), Filter( Prompts, TextSearchBox1.Text in Aufgabe || TextSearchBox1.Text in Prompt ), Ungroup( ForAll( ComboBox2.SelectedItems, Filter( Prompts, Value in Kategorie.Value, TextSearchBox1.Text in Aufgabe || TextSearchBox1.Text in Prompt ) ), "Value" ) )

Remember to replace the comma , with semi colon ;
Kyota 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, @v-qiaqi-msft !

This works like a charm thank you! Just what I was lookin for.

Best Regards,
Kyota