Is Office 365 Get Events Filter Query working?

[efialtes]

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!

[efialtes]

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...

[WiggityZwiggity]

Any idea if this has been implemented yet?

[Anonymous]

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.

[WiggityZwiggity]

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]

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]

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.

[WiggityZwiggity]

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

[Anonymous]

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'))

[ErichH]

Is there an update on this?