cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
s44
Super User
Super User

New problem Cascading dropdown with choice type columns

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

s44_1-1649930038901.png

s44_0-1649930015736.png

 

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:

 

s44_0-1650009347716.png

s44_1-1650009394463.png

 

But when I launch my Power Apps form, it doesn't work, the items of "Filiere" are empty :

s44_2-1650009460233.png

 

Can you help me please ? Thanks in advance ><

15 REPLIES 15

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

s44_0-1650022682351.png

 

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

 

WarrenBelz_0-1650026207966.png

 .

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 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,609)