Office 365 Outlook - Get Events (V4) and recurring/series events

[alex93jansen]

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?

[Alex_10]

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

[francescjp]

Hello:

I think it would be a good solution.

start/Datetime ge '@{startOfDay(utcNow(),'yyyy-MM-ddTHH:mm:ssZ')}' and end/Datetime lt '@{startOfDay(addDays(utcNow(),1,'yyyy-MM-ddTHH:mm:ssZ'))}'

Mark it as a solution if it works please.

Thank you.

Have a good day.

[XavierP]

Hello @francescjp ,
I have a similar problem with my app. I'm trying to retrieve events from my Outlook calandar into a gallery in power apps. Heres what I have for now which is not working.

App.OnStart = 

Set(varCalendrier; LookUp(Office365Outlook.CalendarGetTablesV2().value; name = "Calendrier"; id));;

Set(varStartDate; StartDatePicker.SelectedDate);;

Set(varEndDate; EndDatePicker.SelectedDate);;

Set(varISOStartDate; Text(varStartDate; "yyyy-mm-ddThh:mm:ssZ"));;

Set(varISOEndDate; Text(varEndDate; "yyyy-mm-ddThh:mm:ssZ"));;
*varCalendrier returns a string and Office365Outlook.CalendarGetTablesV2().value returns all my calendar from my Outlook profil, and "Calendrier" is the one I want to appear in my gallery.*

Btn_Rech.OnSelect = 

Set(varEvents; GetEventOutlook.Run(varISOStartDate; varISOEndDate));;

Gallery1.Items = varEvents

Labels in my gallery:
Lbl_Start.Text = "Start : " & ThisItem.varstartdate

Lbl_End.Text = "End : " & ThisItem.varenddate

I also have 2 date picker controls one called "StartDatePicker" and "EndDatePicker".

Heres my Power Automate Flow called GetEventOutlook:
Power Apps (V2)

Type: Text

Name: varISOStartDate

Value: varISOStartDate / @{triggerBody()['text']}

Type:Text

Name: varISOEndDate
Value: varISOEndDate / @{triggerBody()['text_1']}

Get events (V4)

Calendar ID: Calendrier

Filter query: start/Datetime ge @{triggerBody()['text']} and end/Datetime lt @{triggerBody()['text_1']}
Filter by: start/dateTime desc

Respond to a Power App or flow
Type: Date

Name: varStartDate

Value: @{triggerBody()['text']}

Type: Date

Name: varEndDate

Value: @{triggerBody()['text_1']}

Now when I select "July 16 2024" in StartDatePicker and "July 30 2024" in EndDatePicker then I execute my flow I get this error message: "Invalid filter clause: A binary operator with incompatible types was detected. Found operand types 'Edm.String' and 'Edm.DateTimeOffset' for operator kind 'GreaterThanOrEqual'."

In "Gallery1.Items = varEvents_" where theres the "_" it shows an error that is saying:

"GetEventOutlook.Run failed : {
"error": {

"code": 502,
...

I don't understand why it doesn't convert my text input into ISO 8601 then find the events in the calendar and show them in my gallery.

Thanks.