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 / Due date and overdue date
Power Automate
Unanswered

Due date and overdue date

(0) ShareShare
ReportReport
Posted on by 26

Hi

I have a list that in which there is a due date for an inspection, I've created a flow based on a recurrence from information I got here, but I don't really want it to reocurr as such, ideally I'd like an email notificaiton 14 days before due date, then one day before due date, then weekly after due date if the due date has not been changed. The due date would change when the inspection date is updated and another column with inspection period adds on the days till next inspections, which calculates the due date.

 

Below is where I've got to so far, which I tested and it is emailing 14 days prior to due dateFlow.png

Categories:
I have the same question (0)
  • ScottShearer Profile Picture
    25,290 Most Valuable Professional on at

    @DarrenBrown :

     

    I believe that you can meet your requirements by using a recurrence trigger that runs daily.  After the trigger, you could use a series (3?) of get items actions each with an OData filter that will retrieve only the items that meet your requirements.

     

    I just wrote a Flow to respond to a similar question which you can find here.

     

    Take a look at the response I wrote and let me know if this meets your requirements.  If so, please mark your post as Solved. 

     

    Scott

  • CU26081010-2 Profile Picture
    26 on at

    Thanks Scott

     

    Yesterday was first time I've used flow, I'm a total newbie. I'll have a look at your other solution and see if I can get my head around it to modify for what I need

     

    What's an OData filter?

     

    Thanks

     

    Darren

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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 608

#2
Valantis Profile Picture

Valantis 416

#3
11manish Profile Picture

11manish 348

Last 30 days Overall leaderboard