First time poster so forgive me if I’m posting this incorrectly. I’m trying to create an automation where by an email is sent at creation of a new record (through a form). That task seems simple enough, but I’m struggling to connect a separate tab into the flow.
The desired flow is as follows:
- User submits a completed form which includes a division field (ie, business group)
- There’s a lookup to a separate tab which pulls that division contact(s) into the view automatically
- Automation then sends email notifying the division contact of the new record for their review.
Problem is, I can’t get the lookup reference to the division contact to pass the automation test. It continues to say that I’m not referencing a valid email address, which is true, as the lookup is not returning a value but a string.
Any help is appreciated. Glad to answer follow up questions.