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

[Simon_Robinson]

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

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

Anyone any ideas?

[Bellave_Jayaram]

How about CONCATENATE (Formula1+Formula2)

[Simon_Robinson]

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

[Phil]

@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]

@Philip_Garrett_Appsh Doh, forgot about that.

Thanks Philip

[Phil]

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