web

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

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

Power Automate

Unanswered

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)

Chriddle 8,416 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')}'

1 people found this reply helpful.

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
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

Join the conversation