web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Send Reminder 1 hour b...
Power Automate
Answered

Send Reminder 1 hour before the time SharePoint List

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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. 

 

 

Categories:
I have the same question (0)
  • Verified answer
    efialttes Profile Picture
    14,756 on at

    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

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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

     

  • efialttes Profile Picture
    14,756 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 589

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 284 Super User 2026 Season 1

Last 30 days Overall leaderboard