OData filter Events in outlook

(0) Share

Report

Posted on by Gyllentid

894

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.

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

Heartholme 1,278 Super User 2024 Season 1 on at

Like (2)

Report

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

Was this reply helpful? Yes No