Notifications
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 501 Super User 2025 Season 2
Tomac 323 Moderator
abm abm 237 Most Valuable Professional
