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 a form with Power Apps, by connecting to my SharePoint lists. But I don't understand at all how to do this with choice type columns. Everything I try fails. 😞

Can you help me please ? Thanks in advance ! 😞

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @s44 ,

You can do this by filtering the choices in the dropdown, for instance:

DataCardValue3.Items = Filter( Choices([@'Filiere et Sous-filiere'], Value = DataCardValue2.SelectedText.Value ) )

Edit: I'm pretty sure for French locale the comma ( , ) needs to be replaced with a semi-colon ( ; ).

Was this reply helpful? Yes No
Hii_iii 691 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks but it's doesn't work 😞 :
@BCBuizer

Was this reply helpful? Yes No
BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @s44 ,

Apologies, I figured you are using Dropdowns, but you are using ComboBoxes instead. Please use:

DataCardValue3.Items = Filter( Choices([@'Filiere et Sous-filiere'], Value in DataCardValue2.SelectedItems.Value ) )

Was this reply helpful? Yes No
Hii_iii 691 on at

Like
a
(0)

Report
Copy link

Link copied!

It still does not work 😞 @BCBuizer

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @s44,

Here is a duplicated thread that has been resolved, I will mark here to navigate users to the answer.

Thanks for your cooperation.

Was this reply helpful? Yes No