Power Automate Add Days function

Like (0) Share

Report

Posted on 20 Feb 2023 15:42:04 by Community Power Pla...

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!

All responses (1)

Answers (0)

Chriddle 7,724 Super User 2025 Season 1 on 20 Feb 2023 at 17:41:18

Like (0)

Report
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.