cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
5013
Frequent Visitor

Send a summary email whe items are modified in a Sharepoint List using conditions

Hello,

 

I would like to know how to create a flow to get a daily summary email with all the items that have been modified in a Sharepoint List (if changes have been actually made) based on conditions (e.g. if a column has been changed to a certain value).

 

Currently I can make this succesfully per every item that has been modified, it means, I receive several emails, one per modified item. But what I need is to get only one email with a daily summary of the changes, with the modified columns.

Altought the standard "Alert me" offers a summary (daily, weekly...), it is not enough because it sends emails when items are modified no matter what modification has been done (e.g. conditions by columns).

 

Thank you!

 

1 ACCEPTED SOLUTION

Accepted Solutions
RezaDorrani
Dual Super User II
Dual Super User II

Hi @5013,

 

Use filter query to get the data based on your condition and send email.

I have done something similar in this video - https://youtu.be/yeAnuTB85eg

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

View solution in original post

3 REPLIES 3
RezaDorrani
Dual Super User II
Dual Super User II

Hi @5013,

 

Use filter query to get the data based on your condition and send email.

I have done something similar in this video - https://youtu.be/yeAnuTB85eg

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

5013
Frequent Visitor

It works perfectly. And your explanation in the video is great. Thank you!

Hi @RezaDorrani,

 

I have something similar to this issue and i've watched your video before even finding this post. My challenge is that i don't want the trigger to be manual.

 

PowerAppNoob_0-1616050592763.png

I want the email summary to be sent only once. I'm not sure if this can be done. My sharepoint list is modified whenever a form is submitted using power apps. A responder can submit forms several times.

 

Any help will be greatly appreaciated.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (3,508)