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?
do you retrieve calendar events with Power Automate?
i think you need to use 'Get calendar view of events (V3)' action to get recurring events.
in powerapps for example,
Office365Outlook.V4CalendarGetItems() does not return recurring events,
Office365Outlook.GetEventsCalendarViewV3() returns all events including recurring.
User | Count |
---|---|
255 | |
110 | |
90 | |
51 | |
44 |