The solution to this should be easy but so far I have not been able to find the correct syntax.
Dropdown1 is populated using a collection, colPurposes.
I want Dropdown2 to be the same collection less the item selected in Dropdown1.
Dropdown1 items: colPurposes
Dropdown2 items: Remove(colPurposes,'itemContents'=Dropdown1.Selected.'itemContents')
The remove doesn't work.
I have also tried:
RemoveIf,
putting the selection in Dropdown1 in a variable and trying to compare that in the Remove,
Remove(colPurposes,{Value: Dropdown1.Selected.'itemContents'})
I also added temp text fields to display the value in the Selected item.
Any direction appreciated.
.