cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alex93jansen
Helper I
Helper I

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?

1 REPLY 1
Alex_10
Super User
Super User

@alex93jansen 

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.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (3,315)