How to send a report to all emails in a column

[Patrick_Paul]

There’s probably a fairly simple expression that will allow this to happen, but it eludes me at the moment. I have a column that contains several email addresses. I need my report workflow to send a particular emailed report to all of them. How do I get it to send it to every entry in that column. It’s worth noting that it would be a dereference. For example:

I’m executing a report against a table “mentors”
Mentors has a ref column to another table called “location”. That table has a column “emails” that contains the list of emails that the single report needs to go to.

[LeventK]

CONCATENATE(SELECT(TableName[ColumnName], ISNOTBLANK([ColumnName]))

[Patrick_Paul]

OK, that makes sense… so the “To” email address blank(s) in the action can accept a string of emails separated by… Spaces? Commas?

[LeventK]

Commas…It’s a list value