cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PeKi72
Post Patron
Post Patron

How to send email to multiple users with Http request to Sharepoint?

Dear Experts,

I try to send an email to multiple users when an new item in a Sharepoint list is created.

What i would like is to store all the email addresses in a variable and then declare the variable

in the body. How can I do that?

PeKi72_0-1647805790354.png

Gr. P

 

1 ACCEPTED SOLUTION

Accepted Solutions
Mira_Ghaly
Dual Super User
Dual Super User

@PeKi72 

Have you considered using the Outlook connector to send and email and will be much more easier than using the http request and by all mean to construct the body from the SharePoint list group column you can use the below:

Define a claims array to host the multi-choice 

Mira_Ghaly_0-1647816747104.png

Then Loop on the group choice field and append to array variable as below:

Mira_Ghaly_1-1647816820309.png

And this will be the output of the array that you can use in your to in either way if you decide to use Outlook Connector or Send HTTP Request to sharepoint

[
{
"Claims": "i:0#.f|membership|xx@curiousmira.onmicrosoft.com"
},
{
"Claims": "i:0#.f|membership|yy.fahmy@curiousmira.onmicrosoft.com"
}
]

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

2 REPLIES 2
Mira_Ghaly
Dual Super User
Dual Super User

@PeKi72 

Have you considered using the Outlook connector to send and email and will be much more easier than using the http request and by all mean to construct the body from the SharePoint list group column you can use the below:

Define a claims array to host the multi-choice 

Mira_Ghaly_0-1647816747104.png

Then Loop on the group choice field and append to array variable as below:

Mira_Ghaly_1-1647816820309.png

And this will be the output of the array that you can use in your to in either way if you decide to use Outlook Connector or Send HTTP Request to sharepoint

[
{
"Claims": "i:0#.f|membership|xx@curiousmira.onmicrosoft.com"
},
{
"Claims": "i:0#.f|membership|yy.fahmy@curiousmira.onmicrosoft.com"
}
]

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
PeKi72
Post Patron
Post Patron

Thank you it works

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,074)