Share
Report
97Hi Community,
I am trying to find a solution for the following cascading dropdowns and it has been a real headache for me to figure out how to solve this issue!
I have 3 lists created as follows:
1- Asset Categories - Contains a single line text column saved as title
2- Assets List - Contains a lookup column called AssetLookup which gets the data from the 'Asset Categories' list
3- Asset Management - Contains 3 single line text called Asset Category & Asset Used & Serial No.
- I am using PowerApps to customize the form for the Asset Management list & I connected the other lists as Data Sources in my app.
I created a cascading dropdowns for these 3 single line text columns by using the following expressions:
Asset category - gets the data from the asset category list
Asset Used - Depending on the value of the asset category, show the Item Name related to this category, I am using the below formula which compares the AssetLookup column with asset category but this doesn't seem to work!
I tried the same process by using the Asset Category Column in the Assets List as a single line text column rather than a lookup column but this is just not practical for the user to enter each time the category. I am trying to implement it with a lookup column instead.
I need a solution for this please!
Update:
I tried using another of method by using a combobox of the same columns but now I changed them to lookup columns rather than single line text columns and using filtering but unfortunately it also didn't work as I can't display any fields in the Assets Used Combobox. I think I am doing something wrong up there in the expression.
Here is the OnChange expression for Asset Category combobox
And here is the items for Assets Used combobox
I think it would be easier to figure this out by using the second method of the comboboxes but I would appreciate any help that would allow me solve this issue!
All responses (
Answers (
