JasonMMcMahan
Novice

output lookup formula to form field then output to variable

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([Form].[Application 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 

 

 

snip.PNG

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.

0 Kudos
Reply