Send email with options to send multiple requests all at once

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Guys,

I'm Trying to use power automate to send bunch of follow up emails to customers.

My flow is being triggered on occurrence of once per week and should do:

1- Get items from share point list

2-for each item retrieved >> to send an email with options ( Accept invoice - Reject invoice)

however the flow send only one email "the first email" only and wait for it's response before sending any other emails.

Are there an option that i can use to make the flow send all the emails at once and then wait for the replies after then instead of sending them one by one only after receiving the response of the customer to send the new email to the new customer ?

Thanks in advance.

send Email with options!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

hi @Anonymous if you are using an approval you need to wait the response, the conector is maded to do that, but you can use send an email with options to configure the options you want.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you for your reply,

I'm already using send email with options.
However, i send messages with content retrieved from Get items actions which retrieve around 300 Item.

My concern was to send the entire 300 Emails at once and then if any of them is responded then to perform an action depending on the selected option.
However, flow only send one email and wait for the response then it start sending the 2nd email.

Another Question regarding Get Items,
Is it possible to split the retrieved items by counts for example if i have 300 Item retrieved can i split them into group of 40 items each ?

Thanks.

Was this reply helpful? Yes No
RobElliott 10,460 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous If you have an apply to each I recommend you set the concurrency control in the Settings of the apply to each to the maximum of 50. But even with that it will still wait until there are spaces before the next emails are sent. We had the same problem with the Send an email with options yesterday and what we did with this was to add an extra column in our SharePoint list, separate the recipients into groups called A, B, C, D etc of no more than 50 in each group:

then have a separate flow for each group using a filter query to select the group letter:

Rob

Los Gallardos

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This is a brilliant Idea,

my issue is that i can't do that in the SharePoint list as it will need to get updated every week.
i'm looking into something that can group them inside flow it self ( group each 40 or 50 items in an array) and then for each group to start sending the emails.

Are there any function or action that can do this ?

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,

I speculate that Send an email with options should be configured in Apply to each.

So the Send email with options action will not send the next Approval request until one Approval request is completed.

You can do the following settings for Apply to each so that multiple Approval requests can be sent at the same time.

In addition, it is recommended to use Filter Query to filter the items that meet the conditions, so as to improve the operating efficiency.

Best Regards,

Was this reply helpful? Yes No
Pooja08 on at

Like (0)

Report
Copy link

Link copied!

It worked, Thank you for the solution 🙂

Was this reply helpful? Yes No