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.

Tried

List(Formula1,Formula2)

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!