When setting up an email automation "To field is empty"

Hey @BrucePPV, 

Please do the following: 

1. Create a conditional group and add in there the send email action
2. If the email is in a lookup field please verify that you added the value from that email instead the ID
3. How do you test the process? Do you test it by the test button on Automations settings? If so, please select the record again in trigger level and then run your tests again 

Let us know if that worked. happy to help you 🙂 

Thanks
Dimitris Goudis

Hi Bruce,

One potential workaround is to create a formula field and include {Email}, where “Email” refers to the field that contains your client’s contact email. You can name this new field something like “Email (Formula)” and then hide it from the grid view to keep things tidy. Once the formula field is set up, you can add it to the “To:” field in your automation without worrying about formatting issues.

Have you tried retesting your trigger? The automation may be pulling data from an earlier version of the record before it had a email value.

I’ve tired all of these steps and I am still encountering the same issue. With the formula field I tried both the “ARRAYJOIN” function and just duplicating the email field in the formula field. Retested the trigger on the automation each time, same result. 

Could you provide screenshots of your data + automation setup?

Hey ​@Ctelle, what step of your automation is actually getting for the first time the value that should be used as email? If it is the trigger, then retesting the trigger should work. However, if it is not the trigger, but a Find Records action for example, then it is this step that you want to retest.

As mentioned by Adam above, please feel free to send over some screenshots and further detail.

Mike, Consultant @ Automatic Nation 
YouTube Channel 

​@Mike_AutomaticN  let me do some more testing and report back… I may have gotten it fixed based on your comment to look for the part of the automation that pulls the value the first time.