Hello, I have an issue with setting the DefaultSelectedItems.
I am using an If function to determine whether the selected value contains the text _EMAIL
I get a true and then perform a lookup on the choice (dropdown) to set the desired DefaultSelectedItems Value E-mail or Mobile.
If(
LookUp(
Choices([@Requests].VPNGroup),
"_EMAIL" in txtVPNGroup.Selected.Value,
true
),
LookUp(
Choices([@Requests].VPN),
Value = "E-mail"
),
LookUp(
Choices([@Requests].VPN),
Value = "Mobile"
)
)
Unfortunately it isn't setting anything....
Ideally what I would like to do is set E-mail if the selected value contains _EMAIL set Mobile if the selected value does not contain _EMAIL if the selected value is blank / empty then it should be parent.default.
What am i doing doing wrong ? Is there a better way of doing this ?
Any help appreciated.
THANKS