Filter based upon multi-select choice column

(0) Share

Report

Posted on by DanielaHo

241

Hi! 🙂

I need some syntax help please...

There are two lists - 'Scenarios' and 'Tools'. The scenarios list includes choice fields that are represented as dropdown menus within the app. The user filters the data based upon the first 3 columns and the result is 1 item from the 'Scenarios' list.

The second list 'Tools' is shown as a Gallery in the app, and should be filtered based upon the 'Scenarios' list in such a way that all those 'Tools' list items should be shown where the Product Name is in the 'Scenarios' result.

My Problem:

The 'Scenarios' Product name field is a choice column allowing for multiple selections... So in the collection the 'Scenarios result' shows [object Object] as below. I cannot work out how to filter the 'Tools' list from this?

I considered creating a variable that creates a string from all the resulting values, and then filtering 'Tools' list by whether the Tools product name is included in that string. But again, I could not work out the syntax to do that..

Any help would be greatly appreciated!!!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-yutliu-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Hi @DanielaHo ,
Could you tell me what's the data type of Product Name in 'Tools' list?
I assume it's a text column.
I've made a similar tes for your reference:
1)modify your collection:
ClearCollect(test,AddColumns(Coll_Scenarios,"ProductValue",Concat(ProductName.Value,Value&",")))
2)filter data:
Filter(Tools,Product Name in Concat(test,ProductValue&","))
Then, 'Tools' list will filter based on multiple choice column in Scenarios list.

Best regards,
Community Support Team _ Phoebe Liu

Was this reply helpful? Yes No
DanielaHo 241 on at

Like (0)

Report
Copy link

Link copied!

Brilliant - that works!
Thank you so much 🙂 🙂 🙂

Was this reply helpful? Yes No
britagrace 26 on at

Like (2)

Report
Copy link

Link copied!

This looks like a pretty cool app. Care to share?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Yes, as britagrace says, it looks like a candidate for sharing, in the power app community examples, or the github samples. Please do so ;-).

May be interesting to link to a similar question:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Filtering-a-Table-by-a-Multi-Selection-Choice-Column/m-p/1518511#M392477

Also solved by first create a collection, and then filter using in
Clear(colDept); ForAll( ComboBoxName.SelectedItems, Collect(' colDept, Filter( ListName, Value in Department ) ) )

Was this reply helpful? Yes No