Filter a Microsoft Graph call

[dennisb88]

Hi all,

I'm get calendar items with the graph API, that's working fine. But I try to add a filter in my call.

The filter I try to add is that I want only the out of office events. They are showed by the showAs property as 'oof'.

So I tried a couple of things, but my flow failed with the error that the filter action is not valid.

I add the follow URI:

https://graph.microsoft.com/v1.0/users/<EMAILADRES>/calendarView?startDateTime=@{utcNow()}&endDateTime=@{addDays(utcnow(),30)}&$filter=startswith(showAs,'oof')

FYI: Without the filter it's working fine.

Does anyone know how I can filter this right?

[Expiscornovus · Accepted solution]

Hi @dennisb88,

Have you tried using an equals instead of a startswith. Or do you have a specific requirement that you are using a startswith?

https://graph.microsoft.com/v1.0/users/<EMAILADRES>/calendarView?startdateTime=2021-06-15&endDateTime=2021-09-15&$filter=showAs eq 'oof'

[dennisb88]

The eq is working fine! I had not a specific requirement for that! So thank you for helping me out!