Solved

Send an Email not working as it does in O365

  • 22 September 2022
  • 2 replies
  • 6 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



 





 



 



This was in O365





 

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