Solved

Send an Email not working as it does in O365

  • 22 September 2022
  • 2 replies
  • 58 views

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

 

icon

Best answer by ckatz 22 September 2022, 22:00

View original

2 replies

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

Userlevel 2
Badge +5
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