Answered

Converting Microsoft Teams Shifts Time Zones

(0) Share

Report

Posted on by Dan-Golden

Hi all,

I'm having a bit of trouble trying to convert our Microsoft Teams Shifts from UTC to EST. I'm not sure where to output it honestly so I can put the result in our Sharepoint list. Putting the loop itself in there obviously throws back an error.

Screenshot below. Any help would be greatly appreciated, thank you very much!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Dan-Golden :

Do you want to convert the time in the shift list to the time in the specified time zone, and then create items with the obtained data?

If so, the point is the convert time zone must be in the same loop as the create item to work.

However, I think the simpler way is to directly use the formula addHours to directly calculate the date offset.For example:

Reference Expression:

addHours(items('Apply_to_each')?['sharedShift/endDateTime'],6)

Best Regards,

Bof

Was this reply helpful? Yes No
Dan-Golden 61 on at

Like (0)

Report
Copy link

Link copied!

You're a genius. Let me try that right now. Thank you so much.

Was this reply helpful? Yes No
Dan-Golden 61 on at

Like (0)

Report
Copy link

Link copied!
Adjusting the time via expressions worked flawlessly, thank you, sir.

addHours(items('Apply_to_each')?['sharedShift/startDateTime'],-5)
I used -5 for EST! Thanks again.

Was this reply helpful? Yes No