Hi Experts,
I have a sharepoint form with two dropdown combo boxes.
I would like to achieve the following.
If a user selects a particular value in DropdownA I would like DropdownB to be set to a specific value and disabled.
Disabling Dropdown B is a synch.
Dropdown B’s DisplayMode: If(DropdownA.Selected.Value = “particular value”, Disabled, Edit)
But getting the value to set in DropdownB is proving to be a challenge.
What I’ve tried:
1. Setting a variable
DropDownA OnSelect event: If(DropdownA.Selected.Value = “particular value”, UpdateContext({varXX:true}), UpdateContext({varXX:false}))
DropDownB Default: If(varXX, Lookup(Choices(‘Share Point List’, ‘List Column’), value=“specific value”), Parent.Default))
2. Setting the Default depending on DropDownA’s selected value
DropDownB Default: If(DropDownA.Selected.Value = “particular value”, Lookup(Choices(‘Sharepoint List’, ‘list column’), value=“specific value”, Parent.Default))
And
DropDownB Default: If(DropDownA.Selected.Value = “particular value”, “specific value”, Parent.Default)) —> This does not work as it is expecting an object but gets text instead.
Looking to you for advise on how to achieve the desired outcome. This to me should be pretty simply, but I’ve been banging my head trying to figure it out.