Answered

Edit form not showing correct Cascading Dropdown value

(0) Share

Report

Posted on by golfnutt82

1,360

Good morning,
I posted something similar yesterday and didn't get a reply. Maybe I didn't explain the issue correctly, so I am trying again.

I have two fields that work together.
The "Device Type" Field and the "Model Field"

The Model No field on the form is a cascading dropdown field that gets its information from the "Models" list.
There are two columns in the list Title and Device Type. Below is what I am using in the Items property for the Model No field.

Filter(Model,'Device Type'= DataCardValue33.Selected.Result)

This works well for a new form but when I open an edit form it shows all the available choices, but it should show/highlight the choice I originally made in the new form, but it doesn't.

I hope this is clearer.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like (1)

Report

@golfnutt82 You have to set the Default property of that dropdown to Parent.Default

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
golfnutt82 1,360 on at

Like (0)

Report

Hello and thank you for your reply.
I created many custom fields that acted as lookups and those fields did not have "Parent.Default" as the default property setting. I updated those and it works. However, I have another question, whats the difference between Parent.Default and ThisItem.<field name>?

Thanks again.

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (1)

Report

@golfnutt82 Parent refers to the parent control of the current control. In your case the parent of the dropdown is the datacard.

ThisItem refers to the current Item (e.g in a Gallery). You can read more about it here, https://learn.microsoft.com/en-us/power-platform/power-fx/reference/operators#thisitem-thisrecord-and-as-operators

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Dtesnow1018 2 on at

Like (0)

Report

I am having the same issue but my column Items are:
Distinct(listname.columnname) for the "Mfg"
Distinct(Filter(ListName,1stcolumnname = DataCardValue##.Selected.Value),2ndcolumnname)
When I try to apply the suggested fix it does not work. Any help is appreciated.

Was this reply helpful? Yes No