OData filter query on GetItems giving invalid expression error

[smorley]

Hi everyone,

I know there are lots of people with similar questions, but I can't seem to make any of the solutions work.

I have a very simple workflow that is a recurring one that gets new items in a list every morning.  It works fine, but now I want to put an odata filter in it, where the start date is greater than or equal to utcnow().

I get an invalid expression.  Can someone point me in the right direction please?

[tom_riha]

Hello @smorley ,

the Filter Query has always the same format

ColumnInternalName <operator> 'value'

Everything is typed in in the Filter Query field as you have it on the screenshot, the only part where you can use expression is the value part.

Start_x0020_Time ge 'utcNow()'

[smorley]

Hi @tom_riha I really love your blog

My other part of the error is no dynamic content available.  So when I type in Start_x0020_Time that's when I get the invalid expression error.

[tom_riha · Accepted solution]

Thank you. 🙂

Only the utcNow() part is an expression. The rest just type in the Filter Query field.

[smorley]

@tom_riha the error I get now is below. Is that because I need to format the Start time field?

[smorley]

Nevermind - I forgot the quotes around UTCnow().  Thanks @tom_riha