Convert Date/Time to Pacific Standard Time from UTC

(0) Share

Report

Posted on by Dorinda

1,512

I have a flow that works perfectly except when adding the event to a calendar in SharePoint.

Even though the calendar invites is for PST it is still posting in UTC.

I have tried to get this code to work

addHours(items('Apply_to_each')['start'],1,'yyyy-MM-ddThh:mm:ss')

With lots of different +/- of the hours and no success.

Any help would be appreciated.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

MarvinBangert 1,924 Most Valuable Professional on at

Like (0)

Report

Hey @Dorinda
there is an action called "Convert time zone", did you tried this to convert your date into your time zone?

Best regards
Marvin

If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No
Dorinda 1,512 on at

Like (0)

Report

@MarvinBangert yes and still do not get good results

Start time is correct hour just wrong time of day supposed to be PM not AM

Was this reply helpful? Yes No
MarvinBangert 1,924 Most Valuable Professional on at

Like (0)

Report
Hey @Dorinda
just that I understood it correctly:
You have a calendar and whenever there is a new event added, updated or deleted in this calendar, you want to create an item in a SharePoint List, correct?

I am not sure why you would need a compose, parse json and apply to each for, you should only receive one item per trigger, so there shouldn't be any array you run through and the output of your trigger is already parsed.

My flow looks like this:
The "Start" column in SharePoint is a date time column and I use the dynamic content "Start time with time zone".
My calendar element:
My SharePoint item:
My timezone is UTC+2, the information within my trigger is:
{ [...] "subject": "Test Event", "start": "2021-11-12T07:00:00.0000000", "end": "2021-11-12T07:30:00.0000000", "startWithTimeZone": "2021-11-12T07:00:00+00:00", "endWithTimeZone": "2021-11-12T07:30:00+00:00", [...] }

What does happen on your side, when you build the flow like this?

Best regards
Marvin

If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No
Dorinda 1,512 on at

Like (0)

Report

@MarvinBangert

Actually the meeting is being created in Outlook and the flow is adding it to the SharePoint Calendar. It is when it is being added by the flow to SharePoint that the time conversion is a mess.

Was this reply helpful? Yes No
Dorinda 1,512 on at

Like (0)

Report

@MarvinBangert so upon further review it appears the issue is with the Apply to, when you just do it straight no apply to the one meeting entry is entered correctly.

Why would the apply to cause the times to be reset to a different time?

I am so stuck

Was this reply helpful? Yes No
MarvinBangert 1,924 Most Valuable Professional on at

Like (0)

Report

Hey @Dorinda
thanks for further investing in this, but I am still not sure why do you even need an apply to each? The trigger "When an event is added, updated or deleted" runs on only one item, so your return is just one object. Where does your array and apply to each comes from or why is it necessary?

Please give me some more information about, what is missing in my suggested flow with just two items, then I can further invest in helping you to find a solution.

Best regards
Marvin

If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No
Dorinda 1,512 on at

Like (0)

Report

Because it is a recurring event and there are 12 months in the year, so I have it working but it is doing the wrong time

Was this reply helpful? Yes No