Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Sending a single mail for the group of sharepoint items

Hi All,
I want to create a workflow using Power automate and I am starting this workflow on item created. Now when I am adding multiple items at a time it is starting workflow for each item but I want to send all items details in single mail and also I want to know whether the mail triggered or not for that group of items.

I'm inserting common I'd and choice column(yes/no) for group of items.

Can someone please let me know how can I achieve this.
Resident Rockstar
Resident Rockstar

That is not how power automate works. It works based on triggers as you mentioned item created. It will trigger one very item created, it has no idea how to handle your logic basically.


Assuming this is SharePoint - add another column say - NotificationSent default - no.


Then create a scheduled flow, that queries the items on the list using Get Items where NotificationSent eq 'no' you then have a bunch of items in a array you can do what you want with i.e. send 1 email.


You then can update that array of items and set NotificationSent = yes.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors
Users online (2,974)