web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Automatic Flow that se...
Power Automate
Unanswered

Automatic Flow that sends only 1 single email when new items are created on SharePoint Online list

(0) ShareShare
ReportReport
Posted on by 52

I'd like to create a power automate flow that triggers AUTOMATICALLY when new items are created in a SharePoint Online list, then send just ONE single email to a group of recipients. The email will include an attachment of Pending items only. I have been searching all over but could only find solutions for manually trigger flows, not AUTOMATIC.

 

This is what I have so far but it's still sending multiple emails when several new items are added to the list.

 

PAuser_123_0-1692727173621.png

 

PAuser_123_2-1692727218723.png

 

PAuser_123_3-1692727232678.png

 

 

 

Categories:
I have the same question (0)
  • v-qiaqi@microsoft.com Profile Picture
    on at

    Hi @PAuser_1-2-3,

    Because that you use the When a new item is created, that causes a situation that once a new item is created, your flow will run once, which means if you create 2 items, you flow will run twice and send two emails.

     

    Since you have mentioned that there are some solutions, but only use the Manually trigger, that's correct. 

    You need to get all the new items at one time, and group them in single email, that's why this manually trigger works.

  • PAuser_1-2-3 Profile Picture
    52 on at

    This surely defeats the purpose of automation function. Microsoft need to fix this flow feature. It should have an option for single email distribution when multiple items are created. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 323 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 183 Most Valuable Professional

Last 30 days Overall leaderboard