New problem Cascading dropdown with choice type columns

[s44]

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 ><

[s44]

I'm sure, but here "Source de données" is grayed out. Maybe that's the problem? @WarrenBelz 

[WarrenBelz]

@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 ?

[s44]

Yes, single-select dropdowns. And in the Sharepoint list "Categorie" and "Filiere" are of choice type 😕 @WarrenBelz 

[WarrenBelz · Accepted solution]

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).

[s44]

 .

[s44]

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