Announcements
I'm using the Get events (V4) connector (see screenshot below). What's the correct syntax for the odata filter box? This doesn't work:
and(not contains(Subject, 'ABC'),not contains(Subject, 'XYZ')))
Thanks.
Hi @DanHardy ,
OData filtering in the Filter Array does not use the contains syntax. It is recommended that you use the Filter array to filter the desired events.
The following are the function links supported by OData filtering:
OData Filter query in SharePoint Get items in Flow (sharepains.com)
Best Regards,
Sunshine Gu
If anyone else reads this, the output of the Filter Array Action is different than "Get Events" Action. To get it to work, I needed to manually use the expression builder to specify the input of the next action to use outputs('Filter_array')['body'] instead of the body output provided by Filter Array. It seems that whenever I used the body output, it defaulted back to: outputs('Filter_array')['body/value']' instead of just outputs('Filter_array')['body']' which kept giving me an error message.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 592
Valantis 340
11manish 284
