You’re offline. This is a read only version of the page.
350
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
Am I doing something wrong with Filter Query definition?
Thank you in advance!
I find help from here: https://powerusers.microsoft.com/t5/Flow-Forum/Conditions-How-to-evaluate-if-a-date-has-expired/m-p/1721/highlight/true#M219
Using this on my condition it seems to work!!
@equals(substring(item()?['Start'], 0, 10),utcnow('yyyy-MM-dd'))
That has been my experience too not sure how to correctly structure the querries to return the results I expect
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.
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?
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
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.
Any idea if this has been implemented yet?
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."
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (
