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 before d...
Power Automate
Unanswered

Send reminder before due date which was entered on beginning

(0) ShareShare
ReportReport
Posted on by 38

Hi,

 

On beggining of my flow, among other fields I enter "Requested Completion Date". I want to create something like this:

 

1. After a lot of approvals and feedbacks (many flow steps), flow sends email to responsible person to let him know he can start his task (he knows the requested completion date)

2. 3 days before requested completion date I want to send him email with option of comfirm that he finished his task. 

3. He can click the button inside email whenever he wants - but the date of comfirm will be entered to specific sharepoint column. 

4. After comfirm, flow goes next to another responsible person.

 

One of the problems is that task could be very long, for example 3 months. 

 

Do you know how to achieve this ?

 

Thank you

Categories:
  • ScottShearer Profile Picture
    25,331 Most Valuable Professional on at

    @kuglarz96 

    Here are some thoughts on how to accomplish your goal:

    • Use a recurrence trigger that runs daily
      • Using a recurrence trigger avoids the 30 day limitation
    • Use a Get items action with anOData filter
      • The filter will look something like this:
        • RequestedCompletionDate eq 'addDaysutcNoww(),3,'yyyy-MM-dd')'
          • Everything after eq is part of an expression and needs to be entered in the expression window
          • You'll need to check the internal name of the Requested Completion Date column to be sure you are referencing it properly in the filter
    • Send an email to all records returned by Get Items
      • Use a send email with Options action
      • Use another utcNow() expression for the date to enter in SharePoint

    Hope this helps.....

     

     

  • rogrimbe Profile Picture
    Microsoft Employee on at

    Hi Kuglarz96, 

     

    with the below provided informaiton it sounds like you are trying to manage some sort of tasks handling pipline 

    for example PM creates feature -> Dev person developing it -> QA testing it -> Production release it 

    I don't know if there is any 3rd party tool or other integration involved here but I'll address this as a black box. 

     

    in my mind you have 2 flows:

    1) Sender - that checks who is responsible (you decide where to check this and how many times) and sends him emails, one case is the first stage - start the task email and another case is an email X days before Y date which is saved somewhere. ( this can be done in condition with datetime compare)  

     

    the result of the responsible person (button, or the new datetime with the finish task saved somewhere you can access) gets triggered by another flow (2) Updater - that will probably read this change, and update the new responsible person according to your cases in the same place you save the details and the first flow will now trigger again with the new person. 

     

    now it doesn't matter if it takes 1w 3m or 1h they are 2 seperate flows that trigger with different cases

     

    hope it is some help or maybe I misunderstood the entire thing 🙂 

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 445

#2
11manish Profile Picture

11manish 345 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 300

Last 30 days Overall leaderboard