Answered

Filter Query - Get events

(0) Share

Report

Posted on by SBAYXX

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:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

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

Was this reply helpful? Yes No
SBAYXX on at

Like (1)

Report

Perfect - thank you, works like a charm!

Was this reply helpful? Yes No