Schedule a summary email across 12 hours activity

[Lauren_]

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 🙂

[manuelstgomes]

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:

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:

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

[ScottShearer]

@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.

[manuelstgomes · Accepted solution]

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

[manuelstgomes]

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

[jfielder]

@manuelstgomes @ScottShearer  I am trying to do this exact same thing but with "SharePoint Get Files (Properties Only)" where can do I put the "created gt addHours(utcNow(),-12)"