Filter on date with dynamic value

(1) Share

Report

Posted on by CU29071423-0

134

Hi,

I have simple Flow with Dataverse table as my source and trying to apply filter to select records with Date older then 1 week from today. Tried to apply same syntax how I did on gallery filter (..'Date' < DateAdd(Today(),-7,TimeUnit.Days). And learned that it doesn't work, Is it different syntax rules between PApps and PAutomate?
Appreciate if you can guide me if this possible, probably I can use some variable in my flow ?
Below is little excerpt from my flow

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (3)

Sort by

Verified answer

stampcoin 5,153 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@CU29071423-0 Hi,

You can use adddays()

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

or

addDays(utcNow(), -7)

reference link:

DateAdd, DateDiff, and TimeZoneOffset functions Powe app

List of date and time operations for Power automate

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

Tomac 4,072 Moderator on at

Like (0)

Report
Copy link

Link copied!

@CU29071423-0 To expand on @stampcoin's comment, best practice is to always use ISO8601 formatting for dates when doing filters or queries: yyyy-MM-dd (2025-08-22 for today)

As you guessed in your post, Power Automate uses its own syntax for everything. Power Automate Desktop is also different from Power Automate Cloud flows. You get used to it.

If this comment was helpful, please mark it as the answer and also remember to mark @stampcoin's correct comment as the answer.

1 people found this reply helpful.

Was this reply helpful? Yes No
CU29071423-0 134 on at

Like (0)

Report
Copy link

Link copied!

Thanks StampCoin and Tomac !!

Tried to use this expression in Filter box and got and error:

An unknown function with name 'utcNow' was found. This may also be a function import or a key lookup on a navigation property, which is not allowed.

in my Filter box I have it like below:

editdate lt formatDateTime(addDays(utcNow(), -7), 'yyyy-MM-dd')

Was this reply helpful? Yes No
Verified answer

Tomac 4,072 Moderator on at

Like (1)

Report
Copy link

Link copied!

You're almost there! You need to copy the expression into the Expression Editor:

So your filter line will look like this:

In the New Editor, it will look like this:

1 people found this reply helpful.

Was this reply helpful? Yes No
CU29071423-0 134 on at

Like (1)

Report
Copy link

Link copied!

Thanks much Tomac !!!!!
Uff, case closed . I start slowly talk PA language

I tested both Dynamic content and Expression. They both work and look the same after typing and pressing OK.
I assume Fx symbol means Expression.

Was this reply helpful? Yes No