cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
psabios
Regular Visitor

Office 365 Outlook - Get Events v2 is broken

Hi,

 

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.

 

Thanks!

3 REPLIES 3
efialttes
Super User
Super User

Hi

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:

https://powerusers.microsoft.com/t5/Building-Flows/odata-Date-Filter-Not-Working/m-p/39674#M3611

 

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



v-yamao-msft
Community Support
Community Support

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:
https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/use-odata-query-operations-in-sharepoint-...


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.

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

 

capture20171212182404597.png

 

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

 

What am I doing wrong on the syntax? 

 

Thanks!

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Users online (2,495)