"Get calendar view of events (V3)" - Start Time is not properly converting to my timezone

(0) Share

Report

Posted on by DC-19022202-0

I live in the 'Atlantic Standard Time' time zone. I'm trying to write a flow that will send me an email daily at 4 am (Atlantic Standard Time) with all my day's calendar entries. I'm well aware that "Get calendar view of events (V3)" returns everything in UTC, which is fine - I've already taken care of that part. The issue is that it doesn't matter what I do, I can't get the start / end times for "Get calendar view of events (V3)" to return midnight 'Atlantic Standard Time' - they always return midnight UTC. Reading seems to indicate that I should be using:

startOfDay(convertFromUtc(utcNow(), 'Atlantic Standard Time'))
startOfDay(addDays(convertFromUtc(utcNow(), 'Atlantic Standard Time'), 1))

Except as you can see below, when I run the Test Flow, the startDateTimeUtc and endDateTimeUtc output still ends up being midnight UTC time, which means any calendar entry after 8 pm is excluded from the query.

I've been trying to figure this out for 2 days now and I'm starting to get a grumpy with it.

Does anyone know the proper solution for this?

Thanks

dcc

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi,

Pls try to convert UTC midnight to Altantic standard time using the below expression:

convertFromUtc(startOfDay(utcNow()),'Atlantic Standard Time')

If this reply helps & solves the problem, pls mark it as accepted solution.

Thanks,

Manish Solanki

Manish Solanki | LinkedIn

blogs: Manish Solanki

you tube channel: Manish Solanki - YouTube

Was this reply helpful? Yes No
DC-19022202-0 4 on at

Like (0)

Report
Copy link

Link copied!

Thanks Manish - but that didn't really help. It's showing me items the items from yesterday that were between scheduled between 8p and midnight in my time zone.

"startDateTimeUtc":"2026-02-19T20:00:00.0000000",

"endDateTimeUtc":"2026-02-21T07:38:31.5750483",

"$orderby":"start/dateTime asc"}

Was this reply helpful? Yes No
DC-19022202-0 4 on at

Like (0)

Report
Copy link

Link copied!

I fixed the end time, but things are still messed up.

This is my calendar.

This is my revised query:

And this is from the raw output...

Here's the email summary I get...

It's still missing the event named "930p Friday" from today (today is Friday as I write this for those in the future), and it shouldn't be showing my anything from Thursday, but is.

I can't figure out why this is so frickin hard. Exchange On-Prem had a daily calendar summary built in that just worked... M365 has been a nightmare.

Was this reply helpful? Yes No