Skip to main content

Hello,

 

In my current O265 workflow I have an email action that allows me set the TO field using a column in my list that is a calculation.

 

Here is a sample of the calculation (it's used to determine between two users, which one to send the email notification to based on a column being null or not)

 

=IF(ISBLANK(NSample Column]),]User 1],1User 2])

 

If null: sends to user 1

If not null: sends to user 2

 

In Nintext Automate Cloud, I am getting the below error...I made sure that both user 1 and user 2 are in email format

 

26469iD6FFD0A1E10F1A9E.png26470iE5BC0E18DFEA70B4.png

 

 

This was in O365

26471iED16D71324C506B9.png

 

I figured this one out, I had to add a Query to lookup the list the workflow is on after the Start Event. Now I am able to use the calculated column in the TO field of the email action as expected



 



Thank You

Hi @ckatz, I'm glad you were able to find a solution! Thank you for posting your solution here as it will help other folks who may run into a similar issue.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings