Clear DefaultSelectedItems based off a value being set from a dropdown

[lucahydro]

Hey guys,

Hoping some of the big brains trust can guide me on resolving this little quirky issue I am facing. I've searched long and far to find a resolution to this one but coming up short due to a few different scenarios

So essentially I am using a dropdown to bulk change some values within a form. This is done by setting an onchange updatecontext variable and then using that variable to update the defaultselecteditems for other dropdowns within the form. This works well as it updates all of the subsequent dropdowns based off the value selected, i.e. Met/Not Met/NA

The problem I am facing is actually finding the right expression to clear/reset the subsequent dropdowns because the main trigger to set these fields is the primary dropdown. I have tried various reset options and setting variables on a test button click which do technically work, but only work when the subsequent dropdowns are selected individually. When the primary dropdown is selected the reset functionality does not work because the primary dropdown has a selection (I hope that made sense 😀)

I am thinking I need to work out a way to force the main dropdown to reset to the blank value [""] if that's possible? Or setting the default value to [""]?

It's also worth noting, even resetting the main dropdown does not work as the values in the subsequent dropdowns do not dynamically update

Some details of code being used on the dropdowns

Primary dropdown onchange & Items

UpdateContext({varSetAllCC: dropCustomer.Selected.Value})

["","Met", "Not Met", "N/A"]

Other dropdown DefaultSelectedItems

{Value: varSetAllCC}

Edit: I have also tried to do the reset(dropdown) on the OnVisible for the screen but I get an error stating "Reset function can only be used within a resettable control. Controls within a form or gallery can only be reset from within the same form or gallery template"

Much appreciated

Thank you

[M_Ali_SZ365]

Hi @lucahydro ,

Try This

Set the primary dropdown's OnChange property:

OnChange: UpdateContext({varSetAllCC: DropdownPrimary.Selected.Value})
Items: ["","Met", "Not Met", "N/A"]

For subsequent dropdowns, set DefaultSelectedItems property:

DefaultSelectedItems: If(IsBlank(varSetAllCC) || varSetAllCC = "", Blank(), {Value: varSetAllCC})

Fuel our success! 🚀 Give a thumbs up and click 'Solution Accepted' to supercharge our community. Your actions speak volumes!
Warm regards,
Muhammad Ali

[lucahydro]

Hey @M_Ali_SZ365 - thanks for getting back to me 🙌

I tried your suggestion and whilst it allows me to use that expression I am still experiencing the same issue where I cannot reset the subsequent dropdown. The primary column seems to default back to a blank value but the subsequent dropdowns are still showing the values from a previous submission. I need to go into the primary dropdown and select the blank option to force reset the others

Attached a few images if it makes it any easier to understand

Cheers

[M_Ali_SZ365]

@lucahydro ,

try This

To reset the subsequent dropdowns when the primary dropdown changes, introduce a reset variable with the following steps:

Primary Dropdown OnChange:

UpdateContext({varSetAllCC: DropdownPrimary.Selected.Value, varReset: true})

Subsequent Dropdowns DefaultSelectedItems:

DefaultSelectedItems: If(varReset, Blank(), {Value: varSetAllCC})

OnSelect of the Primary Dropdown (or another control to trigger reset):

UpdateContext({varReset: false})

This ensures subsequent dropdowns reset when varReset is toggled true and then set it back to false after the reset is applied.

Fuel our success! 🚀 Give a thumbs up and click 'Solution Accepted' to supercharge our community. Your actions speak volumes!
Warm regards,
Muhammad Ali

[lucahydro]

Hey again @M_Ali_SZ365 .. thanks again for assisting

I tried your changes but its not working as anticipated

For example

Once the primary dropdown is selected to any of the values - the subsequent dropdown does not populate a value (it stays blank).

I put the trigger reset on a test button and once clicked, it will update the value in the primary dropdown to the subsequent dropdown

[M_Ali_SZ365 · Accepted solution]

@lucahydro ,

Try This And Let Know 

Primary Dropdown OnChange:

UpdateContext({varSetAllCC: DropdownPrimary.Selected.Value, varReset: !varReset});

Subsequent Dropdowns DefaultSelectedItems:

DefaultSelectedItems: If(varReset, Blank(), If(IsBlank(varSetAllCC), Blank(), {Value: varSetAllCC}));

Test Button OnSelect (to trigger the reset):

UpdateContext({varReset: !varReset});

Fuel our success! 🚀 Give a thumbs up and click 'Solution Accepted' to supercharge our community. Your actions speak volumes!
Warm regards,
Muhammad Ali

[lucahydro]

Man, I think you nailed it with that last change!

The only tweak I needed to make was adding the reset(primarydropdown) on the button select and its working 100% now!

Thanks so much @M_Ali_SZ365 !!!