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

[PeKi72]

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?

Gr. P

[Mira_Ghaly · Accepted solution]

@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 

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

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"
}
]

[PeKi72]

Thank you it works