Filter Query with Excel Online and Power Automate

[HB4]

Hi there,

I'm trying to build a flow that will filter an excel table but keep getting the same error.

My filter query currently looks like this:

'Reminder' eq'formatDateTime(convertFromUtc(utcNow(), 'E. Australia Standard Time'),'yyyy-MMM-dd')'

And when I try to test it, I continually get this error:

Syntax error at position 26 in ''Reminder' eq'2022-Nov-02''.
inner exception: Syntax error at position 26 in ''Reminder' eq'2022-Nov-02''.
clientRequestId: 055025b4-3276-4a16-93f9-81ed723b9e28

Any sort of help would be greatly appreciated.

HB

[v-chengfen-msft]

Hi @HB4 ,

Please add Expression in this way:

Best Regards

Cheng Feng

[HB4]

Hi @v-chengfen-msft

I have done so but still get the same error.

Any other suggestions?

HB

[v-chengfen-msft · Accepted solution]

Hi @HB4 ,

please do not add quotation marks for Reminder.

Best Regards

Cheng Feng