web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Is Office 365 Get Even...
Power Automate
Unanswered

Is Office 365 Get Events Filter Query working?

(0) ShareShare
ReportReport
Posted on by 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

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

 

Am I doing something wrong with Filter Query definition?

Thank you in advance!

Categories:
I have the same question (0)
  • efialtes Profile Picture
    350 on at

    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/true#M612

  • WiggityZwiggity Profile Picture
    358 on at

    Any idea if this has been implemented yet?

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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 Profile Picture
    358 on at

    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

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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?

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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

  • WiggityZwiggity Profile Picture
    358 on at

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

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

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

  • ErichH Profile Picture
    322 on at

    Is there an update on this?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 796

#2
Valantis Profile Picture

Valantis 568

#3
Haque Profile Picture

Haque 538

Last 30 days Overall leaderboard