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
Solved! Go to Solution.
Hi @Anonymous ,
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
@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."
@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.
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!
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.
Hi @Anonymous ,
Please try this:
Filter(List , CostCentre = Dropdown2.Selected.CostCentre)
Then set the value of dropdown to Manager.
Best regards,
Sik
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
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
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
User | Count |
---|---|
174 | |
111 | |
86 | |
44 | |
41 |
User | Count |
---|---|
238 | |
149 | |
132 | |
77 | |
75 |