Answered

Dynamic filter on collection with multiselect combobox and number range

(0) Share

Report

Posted on by anon_121212

So I have a collection collData and a column Sales (datatype Num). I have a combobox(cmboSales) where I have the Sales value in range format and the items of the combo box are as follows

["1-100", "100-200", "200-300"]

I have implemented a filter on the collection,collData, based on the combobox(cmboSales) as follows

Filter(collData, cmboSales.Selected.Value = "1-100"&& Sales>=1&&Sales<100 Or
cmboSales.Selected.Value = "100-200"&& Sales>=100&&Sales<200
Or
cmboSales.Selected.Value = "200-300"&& Sales>=200&&Sales<300)

Now this is done with multiselect set to false.

How do I make this work with multiselect set to true. I cannot for the life of me figure out how to create a dynamic filter here. I am able to get the filter string by using Concatenate but as it returns a string the filter function is not taking it.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

R3dKap 1,594 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @anon_121212,

First of all, just a little suggestion: use parenthesis to separate the different parts of your Filter() conditions since they combine AND and OR conditions. Something like this (always easier to read as well):

Filter( collData, (cmboSales.Selected.Value = "1-100" && Sales >= 1 && Sales < 100) Or (cmboSales.Selected.Value = "100-200" && Sales >= 100 && Sales < 200) Or (cmboSales.Selected.Value = "200-300" && Sales >= 200 && Sales < 300) )

To answer your questions, try something like this if your combo box is multiselected:

Filter( collData, ("1-100" in cmboSales.SelectedItems && Sales >= 1 && Sales < 100) Or ("100-200" in cmboSales.SelectedItems && Sales >= 100 && Sales < 200) Or ("200-300" in cmboSales.SelectedItems && Sales >= 200 && Sales < 300) )

Tell us if this works...

Was this reply helpful? Yes No
anon_121212 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much. This is exactly what I was looking for and it worked like a charm.

Was this reply helpful? Yes No
R3dKap 1,594 on at

Like
a
(0)

Report
Copy link

Link copied!

Glad I could help... 🙂

Was this reply helpful? Yes No