Unanswered

Syntax error

(1) Share

Report

Posted on by JG23

I am building a Get events (v4). I put calendar for calendar id and my filter query is formatDateTime(utcNow(),'yyyy.MM.dd')

I am getting an error that says: Invalid filter clause: Syntax error at position 8 in '2023.09.19'.
clientRequestId: f4a7a3ce-554c-468f-af67-4211a2b8aee2
serviceRequestId: b8a65e3e-3705-4ed7-83e0-407ae74bc79c

What is wrong with it?

Would love to enter start date being greater than today's date, but don't know how to add that.

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @JG23

Filter query in get events v4 something looks like this:

In the starting I have given start date column. And in eq I have given your expression between two single quotes.

Start/DateTime eq 'formatDateTime(utcNow(),'yyyy/MM/dd')'

I hope this helps 🙂

Was this reply helpful? Yes No
trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

The correct date format for a filter query is '2023-09-19' formatDateTime(utcNow(),'yyyy-MM-dd')

Was this reply helpful? Yes No
JG23 12 on at

Like (0)

Report

For some reason, I have tried both ways and still keep getting errors. In the expressions the DateTime does not populate, and I feel that may be the problem. So I have been manually typing it.

Was this reply helpful? Yes No
JG23 12 on at

Like (0)

Report

I attempted it:
and then received this error message:
error details
Invalid filter clause: Syntax error at position 26 in 'Start/DateTime eq 2023.09.19'.
clientRequestId: 78af9f3f-1f71-4453-b819-477dfdedd5bb
serviceRequestId: ca2f7c0b-1b27-4383-88ef-9a4c389fedf5

Was this reply helpful? Yes No
JG23 12 on at

Like (0)

Report

I attempted your was as well :
Received this error:
Invalid filter clause: Syntax error at position 20 in ''2023-09-19' 2023.09.19'.
clientRequestId: f65a2d82-40c4-42fe-a176-5c6a365084f2
serviceRequestId: a164a8e0-862b-43f7-b609-99620dd33d68

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

@JG23

Two things to correct in it:

In formatDateTime expression write:

slash(/) instead of dots(.)

Or

Dash(-) instead of dots(.)

Like:

formatDateTime(utcNow(),'yyyy-MM-dd')

formatDateTime(utcNow(),'yyyy/MM/dd')

And in the starting of the expression write single quote and at the end of the expression too write a single quote.

Was this reply helpful? Yes No
JG23 12 on at

Like (0)

Report

@Sundeep_Malik Thank you. I did what you mentioned and still get an error.
Start/DateTime eq formatDateTime(utcNow(),'yyyy/MM/dd')

Invalid filter clause: An identifier was expected at position 18.
clientRequestId: b37ec835-bf5c-423d-986e-e1ff68962cc4
serviceRequestId: d5e2c309-79f4-4771-a535-6f05e4602f71

I also put a single quote at beginning and end of expression and says invalid.

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

Ok.

Try this.

Don't add anything in filter query, keep it empty.

Take filter array action pass value coming from get events v4 action.

Then on left side add the start date from the dynamic content.

On right side add:

utcNow('yyyy-MM-dd')

Check with this if you are getting the event you want.

Was this reply helpful? Yes No
JG23 12 on at

Like (0)

Report

@Sundeep_Malik
I made it past the error, but now I get one for the filter array. Guessing I need a value? This is my first time using power automate/ flows to create an attendee registration guide I saw on youtube.

Was this reply helpful? Yes No