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.