Skip to main content

Notifications

Power Automate - Power Automate Mobile App
Unanswered

Having trouble with Conditioning for Overdue tasks Power Automate

Posted on 24 Apr 2024 07:58:30 by 2
[Code for getting Today's Date] (https://i.stack.imgur.com/85hcL.png)

[Screenshot of Flow] (https://i.stack.imgur.com/ZeJmA.png)

[Overdue Condition] (https://i.stack.imgur.com/6SNsR.png)

Hi all, so i created a Power Automate Flow to analyze an excel sheet which contains many tasks and their due date. The flow will automatically send out emails to the person responsible for each task if that task is due soon or already overdue. The due soon part is working fine but the overdue part is not. Even when the person's task is not overdue, there are emails being sent out saying it is, I have included pictures of my flow and the code for getting today's date and the overdue condition. Thank you, Joshua

I tried to initialize a new variable and tried to insert a code that will get me today's date in 'd-MMM-yy' format but no matter how much i tried it just doesn't work.

 

 

  • Suggested answer
    Nived_Nambiar Profile Picture
    Nived_Nambiar 16,540 on 15 Aug 2024 at 18:04:31
    Having trouble with Conditioning for Overdue tasks Power Automate
    Hi,
     
    for date comparision, i always prefer to find the difference b/w the dates and then use the difference value to check whether the date is due soon or overdue.
     
    for example- if today's date is 2024-08-15 and due date is 2024-08-20, then difference b/w dates is 5 days which means 5 days due.
     
    for overdue, if for example , if today's date is 2024-08-15, due date is 2024-08-08. then the date is overdue by 7 days, if taking difference = 2024-08-08-2024-08-15 = -7.
     
    So using this logic it would be easy to do dates comparision.
     
    Refer this artcle to get more details
     
    Thanks & Regards,
    Nived N 
    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs
     Found my answer helpful? Please consider marking it as the solution!
     Your appreciation keeps me motivated. Thank you!

     
     
     

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,168

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,851

Leaderboard

Featured topics