Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Office 365 Outlook - Get Events v2 is broken



I'm trying to use the ODATA filter on the Get Events v2 action and it seems to be broken now after having worked in the past.


My filter is as follows: ShowAs ne 'Oof' and Start ge 2017-12-06T00:00:00.0000000Z and Start le 2017-12-07T00:00:00.0000000Z


This always returns empty results. 


If I remove the date filters, results are returned but this is not a workable solution for I'm trying to do: create a summary of events on the next day to automatically post on Facebook.



Dual Super User
Dual Super User

Re: Office 365 Outlook - Get Events v2 is broken


I haven't tested ODATA myself with Calendar; but I have used it with Sharepoint Lists.


When dealing with Sharepoint, sometimes I need to add a Fiter Array action block instead of ODATA filters. You can see an example here:


Hope this helps

If anyone is trying to help you with an issue, the fastest way to say thanks is by kudoing. Be grateful, Thumbs up!

Proud to be a Flownaut!

Community Support Team
Community Support Team

Re: Office 365 Outlook - Get Events v2 is broken

Hi psabios,


For Date and Time field, you need to use Date and Time functions day() month() year() hour() minute() second() to get the day, month, year first then check whether a date time falls inside a recurrent date time pattern.

Please check this doc for more details:

Please have a try with it on your side.


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Level: Powered On

Re: Office 365 Outlook - Get Events v2 is broken

Sorry, I can't get this to work. If I use the day function in the filter like this:




The query filter contains one or more invalid nodes. clientRequestId: bb28fb4b-6d23-437c-843f-53d775904c79


What am I doing wrong on the syntax? 




Helpful resources


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (7,223)