Using the External: start an email functionality to send an email. Extracting email list

[seyiosinowo]

I am trying to enable my users go to an item click send and send emails to a specified list of users on Appsheet. The current approach I have adopted is creating an action with the action being "External: start an email". That actions creates entry fields for "To", "Subject" and "Body". The "To" section of my email is the most critical, because I am looking for a way to extract value from a virtual column list and put in as the email address(es).

I am attempted this approach. Inserting this into the To section, hoping it will extract the emails and list them (in commas). "TEXT(SELECT([testserviceaccount][email], TRUE))"

So far, the "To" section has remained blank. Any suggestions or ideas of what I might be doing wrong?

Thanks

[Suvrutt_Gurjar]

I believe the action type "External: start an email" is a row level action and expects a single email ID because if one tries to populate it with an email list, it gives the following error.

On the other hand if you code a single email address, the expression is valid as the following screenshot shows.

To achieve your objective of sending email to multiple address, you could use an automation. The automation supports , sending to multiple email addresses in one field. As the following screenshot shows in the highlighted , the list of email addresses is supported.

The below screenshot shows a list of emails is supported.

[seyiosinowo]

Thanks @Suvrutt_Gurjar . The challenges with using bots for us is we would have to build new fields to capture users input prior to sending for the  subject and content fields. We are trying to avoid this as our Apps are getting slow due to the extensive number of columns.

I want to capture the email list and open up a email client. There the user can type without appsheet.

Thanks for the contribution. I appreciate this

[Suvrutt_Gurjar · Accepted solution]

Okay, in the action's "To setting please try an expression of

CONCATENATE("Mailto:", [testserviceaccount][email])

or simply try

CONCATENATE([testserviceaccount][email])

The above assumes that the expression [testserviceaccount][email creates a list of emails.

Please test well. 

[seyiosinowo]

Thanks. This works