cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Converting time zones - Sharepoint List to Flow

Good day. 🙂 I have been struggling trying to figure out the right way to convert time zones for a flow. I have a SharePoint list for new hires for HR. HR staff adds a new hire with their respective start date (no time just MM/DD/YY). I then have a flow that populates an email with the new hire information. I have converted the time zone from UTC to my regional time zone (Eastern UTC -5) as described in MS instructions. However, when the time is converted it is off by a few hours and sends the email with the incorrect date.

 

The date also changes depending on when the HR staff submits the form. EDITED TO ADD: Sreenshot of SP list entry:

dateentered.PNG

 

Sometimes it makes it a day before or after. The time of the SharePoint site is set to my region as well.

 

What could be wrong? HR has stopped using the form as it is creating issues for our whole company. 😞 

 

Flow-Fail.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Converting time zones - Sharepoint List to Flow

Hi @Anonymous,

 

Please refer to screenshot below to create the flow:

Capture.PNG

 

The expression in the "Base Time" field as below:

addHours(triggerBody()?['StartDate'],5)

The flow would run successfully as below:

Capture.PNG

 

Best regards,

Alice

View solution in original post

5 REPLIES 5
WDRC
Level: Powered On

Re: Converting time zones - Sharepoint List to Flow

@Anonymous

 

Try using a compose action like:

 

convertTimeZone(utcnow(),'UTC','W. Europe Standard Time','dd MMMM yyyy')
 
It worked for me in similar situatiion that you seem to have.
 
Regards,
 
Andrew
Anonymous
Not applicable

Re: Converting time zones - Sharepoint List to Flow

Thank you. Not there yet... That worked for the entry added in the morning hours (around 8 am EST) but not for the one added in the pm hours (around 5 pm EST). The email for the afternoon came out with the date after the correct state date. Math anyone? 😕 

TIA! Woman Happy

Community Support Team
Community Support Team

Re: Converting time zones - Sharepoint List to Flow

Hi @Anonymous,

 

Please refer to screenshot below to create the flow:

Capture.PNG

 

The expression in the "Base Time" field as below:

addHours(triggerBody()?['StartDate'],5)

The flow would run successfully as below:

Capture.PNG

 

Best regards,

Alice

View solution in original post

Anonymous
Not applicable

Re: Converting time zones - Sharepoint List to Flow

I think this may be the answer! I will run trials today to make sure but... Why would convert time zone work then? Inquiring minds would like to learn. 🙂 Thanks so much!
Highlighted
Community Support Team
Community Support Team

Re: Converting time zones - Sharepoint List to Flow

Hi @Anonymous,

 

Your local time (in sharepoint) is 5 hours later than the utc time (in flow), and flow would always use utc time, so whenever you get the time from sharepoint to flow, the time would always 5 hours later.

 

So you could add the time difference (5 hours) to the sharepoint time as me in the flow.

 

Best regards,

Alice

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 220 members 5,742 guests
Please welcome our newest community members: