I have a form that users can choose a group, the group is in a separate list and has a related email address for each group.
Example
GroupName | GroupEmail
Group1 | Group1@mail.com
Using the formula
lookup("ApplicationOwners", "ApplicationOwnerGroupName", parseLookup(sForm].pApplication Owner]), "ApplicationOwnerEmail")
In the form users choose a group, a form rule executes the the formula above and populates the field correctly.
However then i want to output the field to a work flow variable then log it.
I created the form variable and query xml using
But for some reason nothing is logged when i try to
Log ApplicationOwnerEmail_wfVar: {Variable:ApplicationOwnerEmail_wfVar}
Any suggestion or help would be greatly appreciated.