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. 😞
For example, I tried to write this:
But when I launch my Power Apps form, it doesn't work, the items of "Filiere" are empty :
Can you help me please ? Thanks in advance ><
Solved! Go to Solution.
The data source drop-down will always be disabled when custom code is used in the Items. I have no more ideas as this simply should work - it is a very basic filter - I assume both of these are single-select combo boxes ?
The below simply should work - particularly when you are not getting any errors (which implies all the references are correct)
Distinct( AddColumns( Filter( 'Categorie et Filiere'; Categorie.Value = DataCardValue2.Selected.Value ), "FiliereValue", Filiere.Value ), FiliereValue ).Result
I assume you see this when you select Edit in the right pane - if so I have no other answer - it simply should work (and does do when I tested it here).
Ohh, I had to change the "Value" to "Result"! It's work now ! Thank you so much for not abandoning me despite this mess :0 !!!! @WarrenBelz