Answered

How to Input Multiple Email Address to a HTTP Request If Met Date Condition

(0) Share

Report

Posted on by burnabywater

I am trying to build a flow where if "Email" field = today's date, the corresponding email will be added to a email draft. The flow I managed to create generates 1 draft email per email address, but I want ALL (multiple) email addresses to be in 1 draft email. So everyone who met the if condition get the same email. Could you please let me know how I should reconfigure to achieve this?

The current JSON code:

{
"subject":"L&L Testing",
"body":{
"contentType":"HTML",
"content":"Hello !"
},
"toRecipients":[
{ "emailAddress":{
"address":"@{outputs('Compose_-_Employee_Email')}" } }
]
}

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-yetonggu-msft on at

Like (0)

Report
Hi @burnabywater ,

Is your 'Name' type a person or group column?

Is it a multi-select column or a single-select person column?

I did a test where the Name column is a single-select person column.

Multiple email addresses can be put into one Send an email request.

My SharePoint List:

My Flow:

item()?['Name/Email'] join(body('Select'),';')

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
burnabywater 16 on at

Like (0)

Report

My "Name/Email" is a single-select person column based on the company's directory, email is stored in Azure.

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Hi @burnabywater ,

My Name column is also a single-select person column. Have you tried the solution I provided?

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
burnabywater 16 on at

Like (0)

Report

Works like a charm 🙂 thank you for very much.

Was this reply helpful? Yes No