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

[5013]

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!

[RezaDorrani · Accepted solution]

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]

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

[PowerAppNoob]

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.

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.