Answered

How can I send one email to users in a multi-user column in SharePoint list?

(1) Share

Report

Posted on by thilla99

I have a SPO list with a multi-user column, each item that gets added to the list would have multiple users in that column.
I'm wanting to send an email to the group of users in the list item periodically, and all the users will be in the "To:" box in the email.
I have built a flow for this, but I when I go to add the multi-user column to "To:" box in the email action, it adds a "apply to each" and sends seperate email to each recipient, not one email to all.

Can you advise how I can acheive this?

Thanks.

All responses (2)

Answers (1)

thilla99 37 on at

Like (1)

Report

Re: How can I send one email to users in a multi-user column in SharePoint list?

Hi again,
This worked great, I had to use "get item" (as oppose to itemS) to retrieve the users from relevant list item.

Thanks,
Thilina.
Verified answer

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (2)

Report

Re: How can I send one email to users in a multi-user column in SharePoint list?

Hello @thilla99 ,
please follow these steps:
1. Get items action:
2. Add an "Apply to each" control and put the previous action "value":

3. Inside the Apply to each loop:
- Add a "Select" action where to add:
- From: the column containing the people;
- Map: the Email value.
- Add a "Join" action where to add:
- From: the Select outputs;
- Join with: semicolon.

In the Send an email action, you can put the Join outputs in the "To" field.

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco