How to send one Power Automate email when multiple items are created?

Like (0) Share

Report

Posted on 19 Jan 2023 07:42:07 by NN-21081740-0

492

Hello

Please help.

I developed a shopping cart using PowerApps and the SharePoint Online as a container for these items.

I then created a Power Automate workflow for notification to the created by.

The issue is that, when multiple items get submitted, multiple emails get generated for each item and that is not what I want.

How can I add all the current items to one email?

Thanks

I have the same question (0)

All responses (7)

Answers (0)

NN-21081740-0 492 on 26 Jan 2023 at 07:15:13

Like (0)

Report

Re: How to send one Power Automate email when multiple items are created?

I tried this template like I said earlier but still...

Was this reply helpful? Yes No
NN-21081740-0 492 on 26 Jan 2023 at 06:25:02

Like (0)

Report

Re: How to send one Power Automate email when multiple items are created?

Apologies for the delay in replying to your message.

This flow works only when you trigger it manually and it also gets all orders.
My aim is to get current orders as they come in and respond to the buyer with one email containing all current orders not historical orders.

Or leave the orders out but at least one email saying we have received your order and will contact you shortly.

Thanks

Was this reply helpful? Yes No
CFernandes 8,305 Most Valuable Professional on 19 Jan 2023 at 10:58:59

Like (0)

Report

Re: How to send one Power Automate email when multiple items are created?

Hey @NC12

Please share the screenshot of your Power Automate.

Was this reply helpful? Yes No
NN-21081740-0 492 on 19 Jan 2023 at 10:54:05

Like (0)

Report

Re: How to send one Power Automate email when multiple items are created?

Hi CFernandes

I appreciate you help.
Here is the thing. The flow has to be automated not triggered manually, therefore I borrowed your scenario but using the automatic flow steps when a new item is created.
This did not work. I submitted two items to the list using the flow and ended up with two emails, each with multiple items of the same thing.

I guess it's because I used "append variable" instead of "service variable".

How can I achieve this using an automatic flow not manually trigger steps?

Was this reply helpful? Yes No
Chriddle 8,141 Super User 2025 Season 2 on 19 Jan 2023 at 08:25:09

Like (0)

Report

Re: How to send one Power Automate email when multiple items are created?

If you can add an "email_sent" column to your list:
After the trigger you use the "Delay" action to wait for other items.
Then you check your list for items with the triggered "created by" without "email_sent" flag set.
Set the sent flag(s) and create the email with these items.

Was this reply helpful? Yes No
Chriddle 8,141 Super User 2025 Season 2 on 19 Jan 2023 at 08:19:26

Like (0)

Report
Re: How to send one Power Automate email when multiple items are created?

If you can add an "email_sent" column to your list:
After the trigger you use the "Delay" action to wait for other items.
Then you check your list for items with the triggered "created by" without "email_sent" flag set.
If you find some, set the sent flags and create the email with these items.

Was this reply helpful? Yes No
CFernandes 8,305 Most Valuable Professional on 19 Jan 2023 at 08:05:19

Like (0)

Report

Re: How to send one Power Automate email when multiple items are created?

Hey @NC12 ,

Option 1 - Create a Table and send it as an email.

Option 2:

Initialize a variable outside the loop

"Set the variable" inside the loop.

Add the variable in the email body.

this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No