Error in LIST Email

Hello,

First of all, I would like to clarify that I am using an BUISNESS PLAN!

Next:
I want to set up an email sent to a group of people among all my users. The common denominator is the same fire station (CIS). That means, when I post an evaluation about a trainee from a CIS Alpha, I want an email notification about the post going live to be sent via a pre-configured workflow.

To achieve this, I created a relation in the evaluation table between the trainee and the trainers of the same CIS. Then, I retrieved the trainers’ email addresses through the relation and checked the “multiple” box. Next, I created a new column that generates an array using the retrieved email addresses as the source. I separated everything using a LIST with commas as the delimiter.

In my workflow, I naturally specified the email list, provided the subject, and wrote the message body. However, I am encountering an error (see photo 1). Strangely, when I manually copy the email list, the email sends successfully. I ensure the emails are separated by commas without spaces.

When I check my email list in the table, everything seems correct—emails are separated by commas without spaces.

I cannot figure out where the issue lies! So, I am reaching out to you for assistance!

Thank you for your help!




Image 4

Try separating them by comma with a space.

Is the list of emails coming from a table under row ownership, and if so does the current user have ownership authority to that data?

always error with space or not

The list is integrated into the row of the table. This list is a relationship between the trainee’s CIS and the trainer’s CIS. I extract a lookup based on the relationship of the trainers’ email addresses corresponding to the CIS. Then, on the same row, I create a “Make Array” followed by a “Join List” to output the email addresses, as for the email sending to work, each recipient must be separated by a comma. When I check the email list data, everything seems correct, but the email is not sent. However, when I manually copy this email line and perform a manual test, it works.
I can’t figure out where the error is.

The error message suggest at least one recipient is not valid. I would check one by one email in those lists, or use a Send Email/Gmail module with the same list to see if it works.