Cascading dropdown with choice type columns

(0) Share

Report

Posted on by Hii_iii

691

Hello, I have 2 SharePoint lists with "Choice" type columns that look like this :

I would like to create "cascading dropdown" on Power Apps like this:

However, I would like the choice of the "Sous-Filiere" category to depend on the choice of the "Filiere" category, but I cannot do this at all. 😞
On my Power Apps, the "Filiere" category comes from the same list as the "Categorie" category.

Can you help me please? Thanks in advance !

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

BCBuizer 22,510 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi @s44 ,

In case these lists are only used for mapping, you can just filter then and add them to the Items property of your dropdowns:

ddFiliere.Items = Filter('Categorie et Filiere', Categorie = ddCategorie.Selected.Value).Filiere ddSous-Filiere.Items = Filter('Filiere et Sous-Filiere', Filiere = ddFiliere.Selected.Value). 'Sous-Filiere'

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your reply. But how do I do if I already have this in "Item" of my "Filiere" dropdown? I need to keep this code 😞 @BCBuizer

Was this reply helpful? Yes No
BCBuizer 22,510 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @s44 ,

I wasn't aware you are actually using a combobox instead of a dropdown. Looking at your code, you may already have a solution, but I guess it is not working for you. At first glance you may want to drop the Distinct function since I assume you don't have duplicate values.

What is the problem with the solution you have?

Was this reply helpful? Yes No