Skip to main content

Notifications

Power Automate - Building Flows
Answered

Filter Query - Get events

(0) ShareShare
ReportReport
Posted on by

Hi

I cannot get my head around how I should build the filter for a Get  events action. I would like the Get events, to only return events which occurs on the same day as the event in the trigger (When event is modified), but 'date eq StartTime' does not work, and I'm not sure how to use the expressions and filter then. 

Flow_filter.png

  • SBAYXX Profile Picture
    SBAYXX on at
    Re: Filter Query - Get events

    Perfect - thank you, works like a charm!

  • Verified answer
    Expiscornovus Profile Picture
    Expiscornovus 31,139 on at
    Re: Filter Query - Get events

    Hi @SBAYXX,

     

    You could use the Start property. However, it seems like you have to use a specific syntax for that field, Start/DateTime. Found that syntax in this thread.

     

    In your example you could try and use this expression:

    In this expression I am using the start field of the changed event and extract the day. With the filter I make sure that I only retrieve events which start on the same day after 00:00 or before 23:59.

     

    Start/DateTime ge '@{formatdateTime(triggerOutputs()?['body/start'], 'yyyy-MM-ddT00:00:00.0000000')}' AND Start/DateTime le '@{formatdateTime(triggerOutputs()?['body/start'], 'yyyy-MM-ddT23:59:00.0000000')}'

     

    startdatetime_getevents.png

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard