Syntax error

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

[Sundeep_Malik]

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 🙂

[trice602]

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

[JG23]

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. 

[JG23]

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

[JG23]

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

[Sundeep_Malik]

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

[JG23]

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

[Sundeep_Malik]

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.

[JG23]

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