How to use formatted value @OData.Community.Display.V1.FormattedValue in List Rows Power Automate

(1) Share

Report

Posted on by MishkaGrizzly

Hi,

If I query a table in Power Automate, I have the following fields

I'd like to use the formatted value field in my List Rows filter like this:

outputs is Todays Date

However the flow then fails with the following error:

Is there a way to achieve what I am trying to do?
Any help is much appreciated

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

MS.Ragavendar 5,036 Super User 2025 Season 2 on at

Like (0)

Report

@MishkaGrizzly,

Can you once confirm that you are trying to get all the records which have the "Follow up date" equals to "Current date" ?

While i going through flow, i understand you are doing that. if yes then what is the "type" of "Follow up date" field if it "Date" field then you can refer below article where you can compare the date field type with the current date.

https://technologyblog.rsmus.com/technologies/microsoft/power-automate-date-filtering-on-todays-date/

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item

Was this reply helpful? Yes No
MishkaGrizzly 55 on at

Like (0)

Report

Hi @MS.Ragavendar

thank your for your response. This worked very well! Thank you again.

One question though. Is there a way to adjust this method to capture start time of Day of one hour earlier?

Because on some of our environments due to the light saving and local settings instead of this value: 2025-04-15T00:00:00Z, we'll have this:

It is the same day (15th) but is being read as previous day (14th) at 11pm

Was this reply helpful? Yes No
Verified answer

MS.Ragavendar 5,036 Super User 2025 Season 2 on at

Like (0)

Report

@MishkaGrizzly,

Time zone difference between UTC time and Ur actual time means for at least part of the day utcNow() will return a different date than the date in your time zone.

Easiest work around is to use addHours() to counter the offset between UTC and your time zone. For eg., I am from IST difference is +5.30

startOfDay(addHours(utcNow(), 5.5))

In that you can make your change, convertFromUTC() function i tried but it didn't give me the result i wanted.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item

Was this reply helpful? Yes No