web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Action 'Get_items' fai...

Power Automate

Suggested Answer

Action 'Get_items' failed: The expression "StartDate eq 2024-12-20" is not valid.

(0) Share

Report

Report

Posted on by BasilH

12

I see there are many queries about this issue - I have been trying for days but always get same or similar result.

I have a list with the following fields:

StartDate (defined as date with date only and standard format selected - internal name is the same -

StartPerson (defined as person or group - people only - internal name is the same

My Get items fails when flow runs

Filter query

However if I replace the expression with a date in the format 'yyyy-MM-dd', it does work.

However I want this to run when the StartDate is eq to todays date.

Please can you provide a valid expression.

Let me know if you need any other information.

Thanks

Basil

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

Chriddle 8,685 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
You have to use quotes, even if you use an expression:

Startdate eq '@{utcNow('yyyy')}'

1 people found this reply helpful.

Was this reply helpful? Yes No
BasilH 12 on at

Like (0)

Report
Copy link

Link copied!

Hi Chriddle thanks for the response but it still fails:

This is what have have changed based on your reply - is thsi correct?

StartDate le '@{formatDateTime(utcNow(), 'yyyy-MM-dd'}'

error when I save the flow

The input parameter(s) of operation 'Get_items' contains invalid expression(s). Fix invalid expression(s) for the input parameter(s) of operation 'Get_items'.

Thanks

Was this reply helpful? Yes No
Suggested answer

BasilH 12 on at

Like (0)

Report
Copy link

Link copied!

Issue solved thanks - needs double single quotes.

thanks

Was this reply helpful? Yes No

Join the conversation