ckatz
Scholar

Send an Email not working as it does in O365

Jump to solution

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([Sample Column]),[User 1],[User 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

 

ckatz_0-1663874519008.pngckatz_1-1663874595780.png

 

 

This was in O365

ckatz_2-1663874712768.png

 

0 Kudos
Reply
2 Replies
ckatz
Scholar

Re: Send an Email not working as it does in O365

Jump to solution

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

Reply
Nintex_Andrea
Moderator
Moderator

Re: Send an Email not working as it does in O365

Jump to solution
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.
0 Kudos
Reply