Hi,
My form has a calculated value control doing a lookup to a SharePoint List within an If statement as follows:
This is working however, when a value is returned true the result comes back like this
I've used the ParseLookup to remove the lookup "ID" prefixed to the result, but I can't understand why it's returned in Square Brackets.
Thoughts? Solutions?