Skip to main content
Nintex Community Menu Bar
Solved

Send an Email not working as it does in O365

  • September 22, 2022
  • 2 replies
  • 64 views
  • Translate

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

 

26469iD6FFD0A1E10F1A9E.png26470iE5BC0E18DFEA70B4.png

 

 

This was in O365

26471iED16D71324C506B9.png

 

Best answer by ckatz

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

View original
Did this topic help you find an answer to your question?

2 replies

  • Author
  • 6 replies
  • Answer
  • September 22, 2022

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

Translate

Nintex_Andrea
Nintex Employee
Forum|alt.badge.img+5
  • Nintex Employee
  • 24 replies
  • September 23, 2022
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.
Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings