web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Filter Query - Get events

Power Automate

Answered

Filter Query - Get events

(0) Share

Report

Report

Posted on by SBAYXX

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.

Categories:

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Expiscornovus 33,995 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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')}'
SBAYXX on at

Like
a
(1)

Report
Copy link

Link copied!

Perfect - thank you, works like a charm!

Join the conversation