cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Lauren_
Level: Powered On

Schedule a summary email across 12 hours activity

Hi everyone,

 

A colleague wants a summary/list email of 12 hours new submission activity in a SharePoint list at two set points (7am and 7pm for example).

 

I daresay this is possible but am unsure how to configure the time schedule & summary instead of individual emails in Power Automate/Flow, so any advice you can offer would be appreciated 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Schedule a summary email across 12 hours activity

Hi @ScottShearer 

 

That's exactly what I wanted to convey. Thanks for clarifying.

 

Cheers

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

View solution in original post

4 REPLIES 4
Super User
Super User

Re: Schedule a summary email across 12 hours activity

HI @Lauren_ 

 

This is possible. Like you said the trigger is the "Schedule" with the times you want it to trigger.

 

Then all you need to do is the following:

small-Screenshot_2019-12-09_at_10_58_07.jpg

 

The formula just removes 12 hours to the current time:

addHours(utcNow(),-12)

 

Then all you need to do is to do a Loop in all items to build the email:

 

small-Screenshot_2019-12-09_at_10_57_59.jpg

 

Makes sense?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Super User
Super User

Re: Schedule a summary email across 12 hours activity

@Lauren_ 

I agree with the solution provided by @manuelstgomes but would like to suggest an alternative to looping through each item and building a string.  You may want to consider using the Create HTML table action.

HTMLTable1.jpg

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Super User
Super User

Re: Schedule a summary email across 12 hours activity

Hi @ScottShearer 

 

That's exactly what I wanted to convey. Thanks for clarifying.

 

Cheers

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

View solution in original post

Super User
Super User

Re: Schedule a summary email across 12 hours activity

HI @Lauren_ 

 

Did the solution work? If not, please let me know so that we can try to help you further.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,833)