Unanswered

Converting time zones - Sharepoint List to Flow

(0) Share

Report

Posted on by Community Power Pla...

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:

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. 😞

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (1)

WDRC 247 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Verified answer

v-yuazh-msft on at

Like (0)

Report
Re: Converting time zones - Sharepoint List to Flow

Hi @Anonymous,

Please refer to screenshot below to create the flow:

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

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

The flow would run successfully as below:

Best regards,

Alice

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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!

Was this reply helpful? Yes No
v-yuazh-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Converting time zones - Sharepoint List to Flow

@v-yuazh-msft , hello. I have the same problem and it does not appear to work.

I used the exact formula you posted and got, I believe, the exact result you got:
Then in the post to sharepoint calendar, I got these results:

In the Calendar, it shows the UTC and essentially is ignoring the time zone conversion and the offset in your suggestion. I've checked my global settings and my SharePoint world is set to PST for the time zone.

The formula I used is this as copied from what you showed. This is only the startdate. I'm testing one thing at a time to try and fix this problem:

Perhaps @Expiscornovus or @Pstork1 may have thoughts on this.

Was this reply helpful? Yes No
Expiscornovus 33,181 Most Valuable Professional on at

Like (0)

Report

Re: Converting time zones - Sharepoint List to Flow

Hi @Anonymous,

Can you try and use the Universal sortable date/time pattern instead? It looks like the Calendar is expecting that format.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Converting time zones - Sharepoint List to Flow

Hi @Expiscornovus ,
Nope. The calendar still has it showing a day earlier. Really weird.

Was this reply helpful? Yes No
Expiscornovus 33,181 Most Valuable Professional on at

Like (1)

Report
Re: Converting time zones - Sharepoint List to Flow

Hi @Anonymous,

I see you are adding 8 hours and converting from UTC-11 to UTC-08.

Can you as a test just use a formatDateTime function in a compose action instead of that Convert Time Zone action above. Put this expression in your compose action and try to put that in either the start or end time of your calendar.

formatDateTime(addHours(triggerBody()?['StartDate'],8), 'u')

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Re: Converting time zones - Sharepoint List to Flow

@Expiscornovus , hello.

I tried it and it didn't work. The formula used was:
formatDateTime(addHours(triggerBody()?['StartDate'],8),'u')
The input output are shown in the pictures.
You can see the outputs from the create item command.
The yes side of the flow is also shown in the pictures.
I'm still ending up with trying to start on the 18th and it shows up as the 17th.
thx

Was this reply helpful? Yes No