OData filter Events in outlook

(0) Share

Report

Posted on by Gyllentid

892

This works

subject eq 'Statistik'

But this doesn't work

contains(subject,'Statistik')
substtringof(subject,'Statistik')

I wish there was a list of what does work as odata filter on different connections. I have made substringof work on Sharepoint, for example but few other places. Does anyone know of such documentation?

Sure, I know I can use Filter Array but it would be nice to be able to limit top count already in the first function.

All responses (1)

Answers (0)

Heartholme 1,278 Super User 2024 Season 1 on at

Like (2)

Report

Re: OData filter Events in outlook

Hi @shavora,

Filter query is indeed a jungle, since you are entering the realm of the underlying infrastructure.

As far as I know there are not any good documentation on which commands works on different filter queries.

I recall this post by @poweractivate; https://powerusers.microsoft.com/t5/General-Power-Automate/Get-events-V4-Filter-Query/td-p/1225601 where he deepdives into Get Events filter queries.

I agree with you, it's always nice to limit the top count in the first function. My approach is usually 1. Scan the web for documentation and/or similar issues. 2. (tedious) Trial and error.

Good luck!

{ If my post answered your question, please Accept it as a solution ✔ }
{ This will in turn help others find solutions to similar questions }

Best Regards
Heartholme