Multi level cascading dropdown

[Anonymous]

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

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

Thanks

[mdevaney]

@Anonymous 

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

[Anonymous]

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

[yashag2255]

Hey @Anonymous 

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!

[Anonymous]

Hi @yashag2255 ,

The data derives from an excel table 

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.

[v-siky-msft]

Hi @Anonymous ,

Please try this:

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

Then set the value of dropdown to Manager.

Best regards,

Sik

[Anonymous]

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

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

Data set

[v-siky-msft]

Hi @Anonymous ,

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?

Best regards,

Sik

[Anonymous]

Hi @v-siky-msft ,

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

[Anonymous]

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

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

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

Please help!

Many Thanks