cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
efialtes
Kudo Kingpin
Kudo Kingpin

Is Office 365 Get Events Filter Query working?

Some days ago I opened a thread related to Office 365 Calendar trigger "On Event Starting Soon".

 

Since Flow staff confirmed there was a bug, I started working with the following workaround: Daily recurrence trigger followed by an Office 365 Calendar Get Events action block.

I'm trying to get just the events that starts the same day the script is executed, so I played with the following ODATA expression on Get Events Filter Query input:

 

date(Start_x0020_time) eq date(now())

 

When executing the script, however, it looks like the filter is not applying as I expected, so all events from target Calendar, no matter the "Start time" they have, are included as output.

 

I've also tried with the following Filter Query

contains(Subject,'prueba')

Taking into account some of the events I've currently programmed does not include 'prueba' in their Subject. However, the filter is not applying as I expected, again all events from target Calendar, no matter which Subject do they have, are included as output..

 

I took as a reference the ODATA documentation from here

http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-url-conventions/odata-v4.0-er...

 

Am I doing something wrong with Filter Query definition?

Thank you in advance!

9 REPLIES 9
efialtes
Kudo Kingpin
Kudo Kingpin

I found a post on powerapps forum covering this topic also, according to response given last 25-april, "filter functionality has not been implemented yet. It's in the plan to support filter query. We don't have a timeline right now."

 

https://powerusers.microsoft.com/t5/PowerApps-Forum/Logic-Flow-Get-Items-Filter/m-p/632/highlight/tr...

Any idea if this has been implemented yet?

 

Anonymous
Not applicable

Hi,

 

I am also very interested if there is solution how to filter calendar events that are retrieved from Office 365 by using Get Events -action.

 

I use Date(event start time -dynamic value) eq Date(Now()).

 

No errors, but it doesn't filter events at all.

I never got it to work, I wasn't sure if it was my syntax or what the issue was but I could not get it to filter appropriately despite dozens of tries

Anonymous
Not applicable

Actually i allready messed up with those dynamic fields.

 

I now started empty flow with push button action. After that i want to get (today) events from my calendar.

 

What a heck i should type on that oData filter field? i should filter events by start date but how?

 

@{utcnow()} gives me current time, but how i filter with that?

Anonymous
Not applicable

I tried also:

1) get all calendar events with get events action

2) with whole result set: add condition event start time is bigger than utcnow(). 

3) send email about every event meets the condition

 

result is that every event passes my condition.

 

Näyttökuva 2016-12-14 kello 17.35.32.png

That has been my experience too not sure how to correctly structure the querries to return the results I expect

Anonymous
Not applicable

I find help from here: https://powerusers.microsoft.com/t5/Flow-Forum/Conditions-How-to-evaluate-if-a-date-has-expired/m-p/...

 

Using this on my condition it seems to work!!

 

@equals(substring(item()?['Start'], 0, 10),utcnow('yyyy-MM-dd'))

Is there an update on this?

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.

Users online (2,543)