Allow multiple emails in "reply" for email bot

AppSheet AppSheet Q&A
1

Hi,

I have an expression that returns an enumlist of user emails. I want replies to emails sent by a bot to go to these emails but the “reply” field will only accept “email” as a type and I have a “List”.

Below is the enumlist that results in multiple emails. This column VC is called [Users Viewing This District]

SELECT(User Assign Alpha[User Id], IN([Unique Id],

FILTER(
User Assign Alpha,
IN(
[_THISROW].[District User 2],
[First Call List To Combine]
)
)))

Can In convert my [Users Viewing This District] list into a string of emails with SPLIT() or something similar?

2

A Reply-To address can only be a singular address; it cannot be a list of addresses.

3 Likes
3

As Steve says, the Reply can only specify a single email address.
Have you tried specifying an single email alias that is configured in your email system to contain a list of email addresses?

2 Likes
4

Hi Thank you,

I used Top and then Text so it picks the first result in the list and accepts it as an email type column.

EXT(TOP(SELECT(User Assign Alpha[User Id], IN([Unique Id],

FILTER(
User Assign Alpha,
IN(
[_THISROW].[District User 2],
[First Call List To Combine]
)
))),1))

1 Like