web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Minus days off todays ...

Power Automate

Suggested Answer

Minus days off todays date within a condition

(0) Share

Report

Report

Posted on by CU06110305-0

Hi, in desperate need of help!

I’m trying to figure out what’s not working but having no luck.

my current flow is Recurrence > Get worksheets > List rows present in a table > Filter Array > For Each > Condition > …..

so my filter array is filtering any rows of data from a spreadsheet that have blanks (no writing) in a specified column.

my condition is that I want to send an email to those rows of data that have blanks in specified column AND the date listed is 25 days or more ago.

So what I’m trying to figure out is how to make the condition work

right now I have for Condition Expression:

AND — 1st Value = Filter Array body (Dynamic) is less than 2nd Value = addDays(Today(-25))

- The error I get says “‘Today’ is not defined or not valid”

How do I fix this? Because it used to work and it’s not anymore, how do I make is defined or Valid??

thanks heaps in advance!!

Categories:

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

LessCodePaths 100 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,

Today() function does not exist in Power Automate.

In Power Automate, there is only utcNow() function, which return current time.

Your formula should become

addDays(formatDateTime(utcNow(),'yyyy-MM-dd'),-25)

This expression is doing two main things:

formatDateTime(utcNow(), 'yyyy-MM-dd'):

utcNow() provides the current date and time in UTC.

formatDateTime(..., 'yyyy-MM-dd') formats this to return only the date (in YYYY-MM-DD format) without the time.

Result: This part outputs today’s date as a string (e.g., 2024-11-06).

addDays(..., -25):

This takes the formatted date and subtracts 25 days from it.

Result: A date that’s 25 days before today, in date format.

Hope it helps

L.
Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@LessCodePaths,

The addDays function also has a format parameter

https://learn.microsoft.com/en-gb/azure/logic-apps/workflow-definition-language-functions-reference#adddays

addDays('<timestamp>', <days>, '<format>'?)

So, you could also use the below and simplify the expression a bit.

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

Join the conversation