web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to filter multiple...

Power Apps

Answered

How to filter multiple choice lit-column with combobox?

(0) Share

Report

Report

Posted on by blabla70

Hello, can anyone tell me what is the syntax for combobox that has to filter from multiple choice column (SP list), based on parent dropdown?

I tried something like this, but it doesn't work:

Filter(Choices(DataSource_Industry.Industry),Town.value=Dropdown3_Town.Selected.Value)

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

WarrenBelz 156,538 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @blabla70 ,

The Items of the second Combo Box would be something like this

Filter( DataSource_Industry, Town.Value = Dropdown3_Town.Selected.Value ).Industry

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
blabla70 on at

Like
a
(0)

Report
Copy link

Link copied!

It doesnt work on multiple choices column (in SP list)...
Verified answer

WarrenBelz 156,538 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@blabla70 ,

Then it would be if Town,Value is a single selection

Filter( DataSource_Industry, Dropdown3_Town.SelectedItems in Town.Value ).Industry

or a bit more complex if Town.Value has multiple selections.

Ungroup( ForAll( Dropdown3_Town.SelectedItems As aSel, Filter( DataSource_Industry, aSel.Value in Town.Value ) ), "Value" )

and display the Industry field in the Combo Box.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Join the conversation