Answered

Cascading Dropdown with multiple choice columns

(0) Share

Report

Posted on by guibe80

Hi there,

I'm creating an app where I want to cascade two dropdown lists, where the data sources are lists with multiple choice columns. I have a table with different products that support different languages for different countries. So, in a list called Products List, I created multiple choice columns Countries and Languages.

In the front end in Power Apps, I need to automatically filter the second dropdown with the languages supported by that country.

I managed to fill in the first dropdown with the following code.

GroupBy(SortByColumns(Ungroup('Products List',"Countries"),"Value",Ascending),"Value","Country")

But when trying I can't fill the second dropdown, I cannot fill the languages available for this country. I'm using the following code, but it's pulling the whole list of languages and not the ones related to the country.

Ungroup(Filter('Product List', ddwn_Country.Selected.Value in Countries.Value).Language, "Language")

How could I filter the second dropdown?

Thanks in advance, this is my first app in Power Apps and still on a step learning curve.

Thanks;

guibe80

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (2)

Sort by

Abhilash_Swain 901 on at

Like (0)

Report
Copy link

Link copied!

Hi @guibe80 ,
For Drop down1 try this :- Sort(Distinct(Products List,Country),Ascending)
For Dropdown2 you can add:- Sort(Filter(Products List, Country = Dropdown1.Selected.result),Ascending)

Was this reply helpful? Yes No
guibe80 16 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply, unfortunately. Ito doesn't work. When running the first query, it's giving me a table as a result and the dropdown cannot parse. This is the result of that expression. This is a multiple choice column.

Was this reply helpful? Yes No
Abhilash_Swain 901 on at

Like (0)

Report
Copy link

Link copied!

I tried the same with a Combobox . Please add this to the Items of Combo box as shown below.

In my 2nd Drop Down I use it like this

Here in My Combobox, I choose multiple Manager,s and in my next drop down Relevant Employee ID will be auto filterd.

Please note:- In operator will have a delegation issue if your data exceed 2000.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @guibe80,

I think you should change your formula that you set for the first Dropdown Items property.

Since you have set Countries column as a Choice column allowing multi select, you could populate the Dropdown with the Choice() function directly.

Here is my solution, please take a try as below.

Set the first Dropdown Items as below:

Choices('Products List'.Countries)

Set the second Dropdown Items as below:

Distinct(Ungroup(Filter('Product List', ddwn_Country.Selected.Value in Countries.Value).Language,"Language"),Value)

Was this reply helpful? Yes No
Verified answer

ymirza 14 on at

Like (0)

Report
Copy link

Link copied!
Is the Value at the end connected with Language.Value? I get an error when doing only Value

Distinct(Ungroup(Filter('Product List', ddwn_Country.Selected.Value in Countries.Value).Language,"Language"),Language.Value)

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

Like (0)

Report
Copy link

Link copied!

Hi, I'm making a form with two dependent dropdowns: Plant or BU depends on the selection you make in Category (both Category and Plant or BU are of type Choice). My problem is in the second dropdown (ddPlant) referring to Plant or BU. I have used the following formula:
Distinct(Ungroup(Filter(Category_PlantBU, ddCategory.Selected.Value in Category.Value).PlantBU, "PlantBU"),PlantBU.Value)

but I get a warning. Also, I have written in Update the following, but it doesn't work:
ddPlant.Selected.Result
Should I change the Default section also?

Can someone tell me the errors I'm getting?
Thank you very much! 😁

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

If it is a Choice column, you should modify the formula as below:

{Value:ddPlant.Selected.Result}

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

Like (0)

Report
Copy link

Link copied!

It doesn't work 😢
Thank you in advance

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

Like (0)

Report
Copy link

Link copied!

How can I solve the warning about the formula below?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

Could you please provide more details like the specific error message?

Also, I don't know what is your warning, is it the red line marked?

Suggest you open a new case for your problem.

Was this reply helpful? Yes No