Search ComboBox SelectedItems in Gallery where values are comma separated

(0) Share

Report

Posted on by Dahiya23

Let's say my gallery shows this when combobox is empty.
Now when i selected FI

I only get fields where FI is presented.

Now i want that if i select FI provide me FI and also FI,CO.

And if i selected FI and CO then it should show FI , CO only.

Is there any way to filter in such a way?

Using this code to filter

Filter(
ABC,
(IsEmpty(New.Result) || combobox in New.Result)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Dahiya23

Filter( ABC, IsEmpty(Combobox1.SelectedItems)|| IsBlank(Combobox1.SelectedItems)|| State in Combobo1.SelectedItems )

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @Dahiya23 ,

Can you try the following formulae and see how it goes?

Filter( source, CountIf( ForAll( Split(Value;","), Result in combobox.SelectedItems.Value), Value) > 0 )

Was this reply helpful? Yes No
Dahiya23 9 on at

Like
a
(0)

Report
Copy link

Link copied!

It shows the same results as i mentioned in question.

Was this reply helpful? Yes No
Dahiya23 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Maybe you got the question wrong.

Was this reply helpful? Yes No
Verified answer

WiZey 3,023 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
I see, my bad I didn't notice the space between the comma and "CO" in your value "FI, CO".

In my tests I used the table ["FI";"FI";"CO";"CO";"FI,CO"] which worked because because I thought the comma was a single-character separator.

In your case, would it be correct to assume your separator is based on two characters: a comma followed by a blank space?

Adjusting the separator in "Split()" should make it work.

Filter( source, CountIf( ForAll( Split(Value;", "), Result in combobox.SelectedItems.Value), Value) > 0 )

Was this reply helpful? Yes No
Yock 45 on at

Like
a
(1)

Report
Copy link

Link copied!

u can setting this properties to get outpout; according ur question, if ur collection is right, then u setting this property can fix the issue

Was this reply helpful? Yes No