Answered

Clear current selection from dropdown when another dropdown value changes

(0) Share

Report

Posted on by AndyJJones

I have some dependant dropdowns that need to be cleared if the "parent" dropdown is changed. I have been prowling the forum to try to find an answer, but nothing seems to be working...

I have a dropdown for "Organization", then another dropdown for "Sub-Organization". If the Organization dropdown changes, I need to clear the selected item from the Sub-Organization since the old value no longer applies, and I need the user to reselct a new valid sub-organization.

These dropdowns are using filtered lists for the vlaues.

Any help would be greatly appreciated!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

wyotim 2,545 on at

Like
a
(5)

Report
Copy link

Link copied!
You could try triggering the Reset property in the second dropdown.

In the OnChange property of the first dropdown, add something like:
UpdateContext({ResetDropdown: true}); UpdateContext({ResetDropdown: false})

In the Reset property of the second dropdown, add:
ResetDropdown
Please note that if you have a default condition set, this is what it will reset to. It is good to ensure that the AllowUnsetValue property is set to true in the second dropdown and that the Default is set to "" to allow a blank default entry.
AndyJJones 44 on at

Like
a
(2)

Report
Copy link

Link copied!
Thank you much for the direction!

It ended up being a bit more complicated that your example, but I ended up setting a "status" flag (ResetL2Status), and set the DefaultSelectedItems to:
If(IsBlank(ResetL2Status),Parent.Default,First(Sort(Distinct(Filter('Orgs',DataCardValue8.Selected.Result=L1),L2),Ascending)))

I think I am well on my way to getting this done now though.

Thanks again!
kpromma 43 on at

Like
a
(0)

Report
Copy link

Link copied!

I have a form with multiple pages... certain set of questions all have their own page. All sourced from a single list. Can this solution be used for each form page?