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

Timezone Issues In Different Offices.

We have a Flow to create Tasks for items added to an Excel file located in our Teams group. When I load in the upcoming tasks, they appear fine for me (in Ireland), but for my US colleagues, they see a 1 day lag on some tasks.

 

We have tried the timezone converter, but didn't have any luck. Any suggestions would be greatly appreciated.

 

Here is the Flow:

 

flow.PNGflow 2.PNG

 

The If statements above are:

 

if(empty(item()?['Start Date']),null,addDays('1899-12-30',int(item()?['Start Date']),'yyy-MM-dd'))
 
if(empty(item()?['Due Date']),null,addDays('1899-12-30',int(item()?['Due Date']),'yyy-MM-dd'))

 

This is the Excel file from Teams:

 

flow3.PNG

 

Thanks.

1 REPLY 1
alaabitar
Solution Specialist
Solution Specialist

Hello,

 

When ever you store a datetime you should always store it in utc timezone so that it will display correctly for all users.

 

Best regards,

Alaa

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,078)