You’re offline. This is a read only version of the page.
Hi,
I am trying to use the Get Events (v4) action with an Odata filter query to retrieve and exchange calendar event with a specific
filter.
This is returning an error. (probably because the body is Html ?? )
I was having the same problem, then I found this other post with a similar question:
I think it is answered there, the "body" field of a calendar event cannot be filtered for, and that's why "Invalid filter clause" comes back. They linked this table here, which seems to be for an API before "Graph" and is marked deprecated, but I think it must still apply ?
Here is the "event" object in the current Graph API, they do not show the "Filterable" column any more:
https://docs.microsoft.com/en-us/graph/api/resources/event?view=graph-rest-1.0
Please someone correct me if I got something wrong here, or if you know a working solution to filter for the event body in the "Get events (v4)" request. As Claude_fr said, it works if you get all events from a calendar, and then use a "filter array" to match the body contents. But I don't think that's quite the right way to do it, or does it actually do the same in the background as filtering in the request ?
Hi @Claude_fr ,
I have made a test and had the same problem.
I thought it might be caused by the contains operator is not supporting this Action.
For example:
Currently, OData filter query operators are limited in Power Automate excel ‘List rows present in a table’ action. Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported.
Maybe that's the reason.
Best Regards,
Charlie Choi
Show the output of Get Events (v4)
It's a 400 error : Invalid filter clause
I don't know the word for the collection 'body' .... body ??
Thx
Hi @Claude_fr,
could you show the error message you get?
Share
Report
8
All responses (
Answers (