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.
@s44 ,
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 ?
Yes, single-select dropdowns. And in the Sharepoint list "Categorie" and "Filiere" are of choice type 😕 @WarrenBelz
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