web

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

Power Platform CommunityForums Power Automate - Building Flows Action 'Get_items' fai...

Power Automate - Building Flows

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:

Business Process Flows

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

BasilH 12 on at

Like (0)

Report

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

Issue solved thanks - needs double single quotes.

thanks

Was this reply helpful? Yes No
BasilH 12 on at

Like (0)

Report

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

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
Chriddle 8,087 Super User 2025 Season 2 on at

Like (0)

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

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

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

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Our Community Code of Conduct has been updated!

Responsible AI policies for the Community

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 787 Super User 2025 Season 2

#2

Tomac 448 Moderator

#3

Power Apps 1919 327

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans