Power Platform Community Forum Thread Details

Hey all,

I am trying to figure out how to use the "get events" function to return upcoming events in the next 3 days (ideally business days, but I can work with 3 days).

I have tried so many variations of the filter query however nothing is working! I have tried at least the below variations (and about 15 more).

$filter=Start gt @{body('Convert_Current_Time_')}

Start gt '@{addDays(utcNow(),3,'yyyy-MM-ddTHH:mm:ssZ')}' and End lt '@{addDays(utcNow(),4,'yyyy-MM-ddTHH:mm:ssZ')}'

$filter=Start gt '@{body('Convert_Current_Time_')}'

Start gt '2024-08-03T23:46:29.6624599Z' and End lt '2024-08-07T23:46:29.6698621Z'

$filter=Start gt 'utcNow()'

Every time I get the same error though:

{
  "status": 400,
  "message": "Invalid filter clause: Syntax error at position 8 in '$filter=Start gt 2024-08-04T00:08:52.0165728Z'.\r\nclientRequestId: 810442d0-3deb-4a61-bc57-12f6f43b28c7\r\nserviceRequestId: 4c8f0622-df71-4db3-90d8-45adbfa45849",
  "error": {
    "message": "Invalid filter clause: Syntax error at position 8 in '$filter=Start gt 2024-08-04T00:08:52.0165728Z'.",
    "code": "BadRequest",
    "originalMessage": "Invalid filter clause: Syntax error at position 8 in '$filter=Start gt 2024-08-04T00:08:52.0165728Z'."
  },
  "source": "office365-ae.azconn-ae-001.p.azurewebsites.net"
}

All I want to do is get all events that start 3 business days hence (not the events before and not the events after) .

So if I run the flow on Monday, 5 Aug 24) I want to get all events starting on Thursday, 8 Aug.

Likewise if I run the flow on Thursday, 8 Aug I want to get all events starting on Tuesday, 13 Aug (3 business days)

Can anyone help??

Categories:

Building flows