News and Announcements icon

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

10

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

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

BasilH 10 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
BasilH 10 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
Chriddle 7,159 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')}'

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Give Back to the Community this Month

Announcing Category Subscriptions!

Quick Links

Leaderboard

#1

WarrenBelz 143,867

#2

RandyHayes 76,308

#3

Pstork1 64,161

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans