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

(0) Share

Report

Posted on 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

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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
Chriddle 8,672 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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
Chriddle 8,672 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
NN-21081740-0 492 on at

Like (0)

Report
Copy link

Link copied!

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
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hey @NC12

Please share the screenshot of your Power Automate.

Was this reply helpful? Yes No
NN-21081740-0 492 on at

Like (0)

Report
Copy link

Link copied!

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
NN-21081740-0 492 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No