Filter Query - Get events

[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. 

[Expiscornovus · Accepted solution]

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]

Perfect - thank you, works like a charm!