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

(0) Share

Report

Posted on by CU16021406-1

1,042

Hi,

What i would like is that if a new item is created in a sharepoint list an email must be sent to certain people.

I have put the email addresses in a variable of the type Array. And i have put the variable into the Apply to Each.

But i do not know what to do next so i can declare it in the body of the email.

I do not want to use other Send Email connectors and i am not authorized to get the sharepoint members. i

just want to get the strings out of the array.

Gr. P

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Hi @PeKi72,

Can you try a body like below:

{ "properties": {"__metadata": {"type":"SP.Utilities.EmailProperties"}, "From":"", "To": {"results":["jane@contoso.onmicrosoft.com","john@contoso.onmicrosoft.com"]}, "CC": {"results":["tim@contoso.onmicrosoft.com"]}, "Body":"Test Body", "Subject":"Hello World" } }

And can you also use these Headers:

{ "Accept": "application/json;odata=verbose", "Content-Type": "application/json;odata=verbose" }

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Hi @PeKi72,

Sorry, I missed the part about the Array variable requirement 😅

Below is an example which includes that array variable as well.

{ "properties": {"__metadata": {"type":"SP.Utilities.EmailProperties"}, "From":"", "To": {"results": @{variables('ToAddresses')}}, "CC": {"results": @{variables('CCAddresses')}}, "Body":"Test Body", "Subject":"Hello World" } }

Was this reply helpful? Yes No
CU16021406-1 1,042 on at

Like (0)

Report

Does not work

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Hi @PeKi72,

Can you change the headers and make sure that both Accept & Content-Type use odata=verbose?

Can you also include the metadata in the body and try again?

Was this reply helpful? Yes No
CU16021406-1 1,042 on at

Like (0)

Report

I can not choose the variable ToAddresses to put it in the body

Was this reply helpful? Yes No
CU16021406-1 1,042 on at

Like (0)

Report

The variable 'ToAddresses' of type 'Array' cannot be initialized or updated with value of type 'String'. The variable 'ToAddresses' only supports values of types 'Array'.

Was this reply helpful? Yes No
CU16021406-1 1,042 on at

Like (0)

Report

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Hi @PeKi72,

If you cannot select the variable from the dynamic content/value list you could alternatively try to use an expression with a variables function instead?

Below is a short gif to demonstrate how you could achieve this.

Was this reply helpful? Yes No
CU16021406-1 1,042 on at

Like (0)

Report

Was this reply helpful? Yes No