Multiple selected values cascading dropdownlist

(0) Share

Report

Posted on by superduperchar

I am currently working with multiselect cascading dropdown value.

SharePoint list configuration.

In Customer List, i have populate value for Make based on customer list

1. Make dropdownlist

Choices([@'Customer'].Make)

Now I would like to filter second dropdownlist called Model based on Multiple selected value in Make dropdownlist.

i.e if User select Toyota, Mazda in Make dropdownlist, it will populate all model values based on Toyota and Mazda

Customer list

Make (multichoice lookup table from Car list)

Model (multichoice lookup table from Car list)

Car list

Make(Text field)

Model(Text field)

Make Model

Toyota	Hilux
Toyota	Kluger
Toyota	Prius
Mazda	CX9
Mazda	CX7
Mazda	CX5
Honda	Civic
Honda	Odessey

I have the following filter on Items

Filter(Choices([@'Customer '].Make), Id in Filter(Choices([@'Customer '].Model), Value = Model.Selected.Value).Id)

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @superduperchar ,

Please try:

Filter( Choices([@'Customer '].Make), Id in Model.SelectedItems.Id )

Best Regards,

Bif

Was this reply helpful? Yes No
superduperchar 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Bif,

Thank you. It seems only display 1 items from Make. So based on the your suggestion above. If I select Toyota, it popuplate Hilux. It should popuplate Hilux, Kluger, Hilux

Test 2. If I choose Toyota, Mazda
It display Hilux, CX9
It should display Hilux, Kluger, Hilux, CX9, CX7, CX5

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @superduperchar ,

Please try:

Filter( Choices([@'Customer '].Make), Id in Filter(Choices([@'Customer '].Model), Value in Model.SelectedItems.Value).Id )

Best Regards,

Bof

Was this reply helpful? Yes No
superduperchar 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your proposed solution Bof. I have tried however it still displaying one record under Model dropdownlist.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @superduperchar ,

Please try:

1\Set the Make combobox's items property to:

Choices([@'Customer '].Make)

2\Set the Model combobox's items property to:

Filter( Choices([@'Customer '].Model), Id in Filter('Car list',Make in Make.SelectedItems.Value).Id )

Best Regards,

Bof

Was this reply helpful? Yes No
superduperchar 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Make dropdownlist (Items): Distinct(Choices([@'Customer'].Make),Value)
Model dropdown (items): Filter(
Choices([@'Customer].Make),
Id in Filter(Choices([@'Car'].Model), Value in Make.SelectedItems.Value).Id
)
No value due to error in Id highlighted in red error message: Name is not valid, Id is not recognised.

Was this reply helpful? Yes No
superduperchar 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Bof, If I put Model dropdown (items): Filter(
Choices([@'Customer].Make),
Id in Filter(Choices([@'Car'].Model), Value in Make.SelectedItems.Value).Model
)

Error message in error highlighted . 'Delegation warning. The highlighted part of this formula might not work correctly due to large dataset.

The following return result however it only returns result models from one Make ie. Toyota even if choose Toyota and Mazda
Distinct(Filter(Car, Make = Make.Selected.Value), Model)

Was this reply helpful? Yes No