Unanswered

Need help, Sending email to multiple people from people picker in sharepoint list

(0) Share

Report

Posted on by PBala

Hi,

I am trying to send email to multiple people in a people picker field in a SharePoint list. My flow send email to all the folks in the "Requested On Behalf of Field" in the complete list instead people in one list item. Any help is appreciated.

Thanks

All responses (9)

Answers (0)

PBala 95 on at

Like (0)

Report

Re: Need help, Sending email to multiple people from people picker in sharepoint list

Hi Rob,

Any suggestion how to fix my issue?

Any help is appreciated.

Thanks
Pbala
PBala 95 on at

Like (0)

Report

Re: Need help, Sending email to multiple people from people picker in sharepoint list

Hi Alice.

Any suggestion how to fix my issue.

Thanks
PBala 95 on at

Like (0)

Report

Re: Need help, Sending email to multiple people from people picker in sharepoint list

Above is my output, For each loop, it goes through the Values and then Requested On Behalf of values (Email address) gets appends to string (Email). But for Sent to, (Email) variable, it aggregates all the Requested on Behalf of email address in one email.

Thanks, Any help is appreciated.
PBala 95 on at

Like (0)

Report

Re: Need help, Sending email to multiple people from people picker in sharepoint list

I think when I do Apply to Each Value and then Variable,(Email), in the send to email, it aggregates all the email address.
PBala 95 on at

Like (0)

Report

Re: Need help, Sending email to multiple people from people picker in sharepoint list

Hi Rob,

Thanks for the response. Attached is my flow images. I am initializing a variable but doing something wrong in the loop. Any help is appreciated. Thanks
PBala 95 on at

Like (0)

Report

Re: Need help, Sending email to multiple people from people picker in sharepoint list

Hi Alice,
When I add flow images as insert photos, it does not show let me try again.
Community Power Pla... on at

Like (0)

Report

Re: Need help, Sending email to multiple people from people picker in sharepoint list

Hello @RobElliott ,

Could you have a look at my problem too:

https://powerusers.microsoft.com/t5/General-Power-Automate/Send-email-with-multiple-attachments-from-SP-list/m-p/461697#M45447

Thanks in Advance,
Sanket
v-alzhan-msft on at

Like (0)

Report

Re: Need help, Sending email to multiple people from people picker in sharepoint list

Hi @PBala ,

Could you please share a screenshot of the sharepoint list and explain more details about your requirement?

Best regards,
Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RobElliott 10,157 Super User 2025 Season 1 on at

Like (0)

Report
Re: Need help, Sending email to multiple people from people picker in sharepoint list

@PBala the way I would do this is with a button on the SharePoint list to trigger the flow. You format the column and copy in the JSON code below but use your flow id from the browser address bar in place of my id shown in bold in the image.

The SharePoint list has a multi-select People column called People.

The JSON code is:

{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "button",
"txtContent": "Send Email",
"customRowAction": {
"action": "executeFlow",
"actionParams": "{\"id\": \"e0e5590c-68c9-40a6-ae6e-dc7f8ac6afd0\"}"
}
}

Then in the flow the trigger is a SharePoint For a selected item. The first action is to Initialize a variable, give it a name and set it to String.

Next, add a SharePoint Get item action and select ID from the dynamic content.

Then add an Apply to each and select People from the dynamic content.

Inside the apply to each add an Append to string variable, select the variable you initialized earlier and in the Value field select People Email from the dynamic content. Add a semi-colon after it.

Still inside the apply to each add the Send an email (V2) action and in the To field select the variable.

A separate email will be sent to each person in the People column.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.