Office 365 Outlook - Get Events (V4) and recurring/series events
I use the following filter query to retrieve all events from my Calendar that took place on 6/14/2021 UTC-8:
start/dateTime ge '6/14/2021 8:00 AM' and end/dateTime le '6/15/2021 8:00 AM'
Where the start and end times are provided through PowerApps variables.
The issue is that this query doesn't retrieve any events that are part of a series with a start/end date outside this range . e.g. for 6/14/2021, I had 3 single events, one daily recurring event from 6/14 to 6/16, and one daily recurring event from 6/1 to 6/30. The first 4 events were correctly retrieved, but the final one wasn't.
I tried switching around the operators to:
start/dateTime le '6/15/2021 8:00 AM' and end/dateTime ge '6/14/2021 8:00 AM'
but it made no difference.
How do I adjust my filter so that it retrieves ALL events for a given day?