Power Platform Community Forum Thread Details

Hi 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!

Categories:

Building Power Apps