Send email using actions

[Firdaus_AG]

Hi everyone,

I try to use actions to send an email to users. I used the following formula to get the lists of email.

CONCATENATE(
  SELECT(
    Student[Email],
    IN([Tutorial], SPLIT(LOOKUP(USEREMAIL(), "User", "Email", "Tutorial"), ",")),
    TRUE
    )
  )

The problem is only the first email displayed. I try to insert the email adress manually, i.e "email1@email.com,email2@email.com,..." and it working fine. Anyone please help me to fix this.

Thank you.

[Steve]

Please post a screenshot of the configuration of the action.

[Firdaus_AG]

To:

TEXT(
  SELECT(
    Student[Email],
    IN([Tutorial], SPLIT(LOOKUP(USEREMAIL(), "User", "Email", "Tutorial"), ",")),
    TRUE
    )
  )

Subject: 

"ePP Token"

Body:

"Please use ePP Token "&[My Token]&" to answer ePP Survey. Please click "&hyperlink(encodeurl("https://www.appsheet.com/start/1a91e66e-ccd3-4235-9015-a7af017f336b#view=e-Penilaian%20Pensyarah"),"here")&" to answer the ePP Survey.

fteam"