Answered

Syntax error with ODATA filter query, formatDateTime

(1) Share

Report

Posted on by JH-30040830-0

I am trying to get information from an Excel workbook and then filter the results by a yesterdays date. Each time I add formatDateTime to the ODATE filter, it fails.

My filter is DATE eq '@formatDateTime(addDays(utcNow(),-1),'yyyy-MM-dd)'

I can't see the problem with this statement.

Further to a straight formatDateTime, I have used 2 Compose operations. One to subtract a day and one to format the date, but each time I use formatDateTime it fails.

Any ideas?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Matthias PPS 70 on at

Like (0)

Report
Copy link

Link copied!

@JH-30040830-0 What is the error message?

Was this reply helpful? Yes No
JH-30040830-0 4 on at

Like (0)

Report
Copy link

Link copied!

It just says there is invalid syntax at a position. I have taken this further, I tried just using addDays, but as soon as I put a format in it failed with the same syntax error. It always says the date format is invalid

Was this reply helpful? Yes No
Verified answer

stampcoin 5,158 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@JH-30040830-0 Hi,

According the info you provided:

Please refer to this one:

DATE eq '@{formatDateTime(addDays(utcNow(), -1), 'yyyy-MM-dd')}'

Advanced mode:

OData filter expects dates in quotes.
Power Automate expressions must be wrapped in @{} for evaluation.
You must not include additional single quotes outside of the expression, otherwise the evaluation won't occur correctly.

Enjoy Power Platform and have a great day 🚀 | My LinkedIn

If the answer helps, please consider 👍, Thanks.

Was this reply helpful? Yes No