Return multiple email addresses defined by role

Illes M

Hello, I want to notify people through an automated workflow. The notification should be sent to persons related to a certain role and the role-name list is stored in a separate sheet. There can be a single name or multiple names. How can I join contact values, so the joined values will give email addresses? The join function doesn't seem to work:

=JOIN(COLLECT(Name:Name; Role:Role; "LOG-SAP-pricing"); ",")

the names are transferred, but not the email addresses (like First1 Last1,First2 Last2).

I want to receive a cell value containing a single or multiple email addresses, which can be referenced in a workflow.

Many thanks

Jeff M.

Have you tried formatting the column properties to a contact list?

Illes M

Hello, yes, it's formatted like a contact list.

Andrée Starå

Hi @Illes M

I hope you're well and safe!

Unfortunately, it's not possible to use a formula to collect multiple contacts, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

I hope that helps!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!