cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Multi level cascading dropdown

Hi, 

 

I am trying to build a multi level cascading dropdown. It seems to have worked for the first two dropdowns but when I apply it to the thrid dropdown which is dependent on the second dropdown, the third dropdown doesnt display the results eventhough the formula bar returns the desired result

Capture.JPG

Any ideas why this is or where I've gone wrong?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Multi level cascading dropdown

Hi @HVL ,

It seems that your excel data doesn't connect to PowerApps successfully.

Could you try to use Data Table control to display it and check if the data has been connected?

If so, the followings are some suggestions, please have a try.

1. re-create a new table to test

2. remove any formulas, PowerApps not support calculated columns in excel

3. remove comments, hidden columns

4. save and close the excel, then connect to excel in PowerApps

Best regards,

Sik

View solution in original post

10 REPLIES 10
Highlighted
Super User
Super User

Re: Multi level cascading dropdown

@HVL 

There are a few ideas I have about what could be wrong here but lets start with the simplest one.

 

Try this code instead.  LookUp finds the first matching CostCenter in List and returns the Manager field.

LookUp(List, CostCentre = Dropdown2.Selected.CostCentre, Manager)

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Highlighted
Helper III
Helper III

Re: Multi level cascading dropdown

@mdevaney  thanks for your suggestion. Although it returns the desired result (refer to the formula bar), it shows as an error and doesn't display the text in the dropdown field. The formula I used previously 

 

Filter(List,CostCentre = Dropdown2.Selected.Manager) also returns the desired result but doesn't show the value in the dropdown field.

 

Capture.JPG

 

Highlighted
Dual Super User
Dual Super User

Re: Multi level cascading dropdown

Hey @HVL 

 

Can you please confirm the type of CostCenter in the List?

If this is a single line of text field:
Filter(List,CostCentre = Dropdown2.Selected.Manager)

If this is a lookUp type column:
Filter(List,CostCentre.Manager = Dropdown2.Selected.Manager)

Note: Make sure that you are passing the correct column names in the formulas. If this differs, please share more details about the list, so that we might be able to help you better.

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Highlighted
Helper III
Helper III

Re: Multi level cascading dropdown

Hi @yashag2255 ,

 

The data derives from an excel table 

capture 2.JPG

The format was default to 'General' and I just changed to 'Text', however, same result. I'm confused as to why the field is blank despite the formula bar showing the desired result.

Highlighted
Community Support
Community Support

Re: Multi level cascading dropdown

Hi @HVL ,

 

Please try this:

Filter(List , CostCentre = Dropdown2.Selected.CostCentre)

Then set the value of dropdown to Manager.

Snipaste_2019-12-06_17-30-39.png

Best regards,

Sik

Highlighted
Helper III
Helper III

Re: Multi level cascading dropdown

After playing around a little, I managed to get it to display the text by changing the value to 'Manager'

Capture.JPG

 

However, when recreatinga single dropdown with a different data set, the problem reoccurs and the field is blank.

 

Data set

capture 2.JPG

 

capture 3.JPG

Highlighted
Community Support
Community Support

Re: Multi level cascading dropdown

Hi @HVL ,

 

Your code looks good, Are you able to see the Result in formula bar?

Could you try to delete the connection and re-add it again to check if your issue is fixed?

Snipaste_2019-12-06_17-52-54.png

Best regards,

Sik

Highlighted
Helper III
Helper III

Re: Multi level cascading dropdown

Hi @v-siky-msft ,

 

I have tried removing connection and readding but still the same problem.

Highlighted
Helper III
Helper III

Re: Multi level cascading dropdown

This is becoming really baffling and the results seem to be intermittent.

 

The data source is an excel table which is pulled from a power query. Below are a few of the columns

capture 2.JPG

I created a connection to the data source in Powerapps then created a cascading dropdown

 

capture 4.JPG

 

However, the dropdown does not work and allow me to select any items.

 

Please help!

 

Many Thanks

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,508)