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?
A Reply-To address can only be a singular address; it cannot be a list of addresses.
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?
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))
User | Count |
---|---|
15 | |
12 | |
9 | |
8 | |
4 |