Skip to main content

Notifications

Community site session details

Community site session details

Session Id : e0G5iuZDuUZEJTi7kmXroY
Power Automate - General Discussion
Unanswered

Power Automate Add Days function

Like (0) ShareShare
ReportReport
Posted on 20 Feb 2023 15:42:04 by

Hi all, 

I want to send a notification in Power Automate when my due date has elapsed by 5 days.   I have been using the 'Add Days' expression but I can't get it to work, any advice on this would be great, thanks! 

JL6_0-1676907631679.png

 

  • Chriddle Profile Picture
    7,704 Super User 2025 Season 1 on 20 Feb 2023 at 17:41:18
    Re: Power Automate Add Days function

    If you care about time, this expression is it (although checking for equality would be useless)

     

    addDays(utcNow(), -5) 

     

     

    If you are only interested in the day, you need to format your Due date (remove the time)

     

    formatDateTime('2223-02-10T13:30:30', 'yyyy-MM-dd')

     

    (Replace '2223-02-10T13:30:30' with your Due Date expression)

    and remove the time from the utcNow expression

     

    addDays(utcNow(), -5, 'yyyy-MM-dd') 

     

     

    I am assuming your due date is a valid ISO 8601 date string.

    If not, further adjustments may be required.

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - General Discussion

#1
ankit_singhal Profile Picture

ankit_singhal 7 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 4 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 2 Super User 2025 Season 1

Overall leaderboard
Loading started
Loading complete