Send Reminder 1 hour before the time SharePoint List

[keyboardWrench]

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. 

[efialttes · Accepted solution]

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

[keyboardWrench]

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?

[efialttes]

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