cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lauren_
Advocate III
Advocate III

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

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

5 REPLIES 5
manuelstgomes
Super User II
Super User II

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

ScottShearer
Super User III
Super User III

@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

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

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
Frequent Visitor

@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)"

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (39,825)