I want to send an email from a workflow using...

(Simon Robinson) #1

I want to send an email from a workflow using 2 formulas.

The first will always pull 1 email address from table1.

Whereas the second forumla will pull a list of emails from table2.

Both formulas work fine, but I’m not sure how to combine them.



in the To box of the workflow.

But it says this can’t be a list :frowning:

Which is odd because the output of formula2 is itself a list.

Anyone any ideas?

(Bellave Jayaram) #2

How about CONCATENATE (Formula1+Formula2)

(Simon Robinson) #3

Won’t I end up with 123@abc.com456@abc.com?

(Philip Garrett) #4

@Simon_Robinson There is no need to combine the two formulas. You can click the + under “To” and enter each formula on in its only line.

(Simon Robinson) #5

@Philip_Garrett_Appsh Doh, forgot about that.

Thanks Philip :slight_smile:

(Philip Garrett) #6

@Simon_Robinson Glad to help Simon. Thanks for using AppSheet!