web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate OData filter Events in...

Power Automate

Unanswered

OData filter Events in outlook

(0) Share

Report

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:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Heartholme 1,278 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

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

Join the conversation