cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
keyboardWrench
Helper III
Helper III

Send Reminder 1 hour before the time SharePoint List

Hello, I have a SPO list that has tasks with Due Date & Due Time. 

 

How do I send an email reminder an hour before the set due date and time. Some of the time in the list is due HH:30 (eg: 1:30 AM, 4:30 PM).

 

Any ideas will be appreciated. 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
efialttes
Super User III
Super User III

Hi!

How many tasks shall be reminded daily?

If less than 50, I would do the following:

 

1.-Schedule trigger to be executed everyday at 00.00

2.-'Get items' action block, assign as 'Filter query' an ODATA expression to identify those items whose Due Date is today

3.- 'Apply to each' action block, assign as its input 'Get items' output, set it to paralel execution, 50 concurrent executions. Now, inside 'Apply to each':

3a.- 'Delay until' action block, assign as its input one hour before DueDate&Time

3b.- 'Send an email' action block

 

If you expect more than 50 reminders daily, I would follow a nested flows approach, implement a second flow HTTP triggered (premium) that shoud receive details of a single item and would take care of 'Delay until' and 'Send an email' action blocks, so the first flow will keep recurrence trigger, 'Get items', 'Apply to each', and inside 'Apply to each' HTTP action block to invoke the second flow....

...or keep a single flow, setup your Schedule trigger to run every six hours, or even hourly

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

3 REPLIES 3
efialttes
Super User III
Super User III

Hi!

How many tasks shall be reminded daily?

If less than 50, I would do the following:

 

1.-Schedule trigger to be executed everyday at 00.00

2.-'Get items' action block, assign as 'Filter query' an ODATA expression to identify those items whose Due Date is today

3.- 'Apply to each' action block, assign as its input 'Get items' output, set it to paralel execution, 50 concurrent executions. Now, inside 'Apply to each':

3a.- 'Delay until' action block, assign as its input one hour before DueDate&Time

3b.- 'Send an email' action block

 

If you expect more than 50 reminders daily, I would follow a nested flows approach, implement a second flow HTTP triggered (premium) that shoud receive details of a single item and would take care of 'Delay until' and 'Send an email' action blocks, so the first flow will keep recurrence trigger, 'Get items', 'Apply to each', and inside 'Apply to each' HTTP action block to invoke the second flow....

...or keep a single flow, setup your Schedule trigger to run every six hours, or even hourly

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Hi @efialttes  thanks for your response.

 

The task each day sometimes is more that 50 depending on the day. Each day there a different task.

I believe your second alternative is the best approach.

 

@efialttes  I have never use HTTP request and this new to how do use this for my solution?HTTP_Request.jpg

 

You can also keep a single flow, setup your Schedule trigger to run every six hours, or even hourly

 

But if you wanna explore the nested flow approach, great stuff here

https://flow.microsoft.com/es-es/blog/build-nested-flows/

 

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Automate User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

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 (42,835)