Task Completed Date and Time in wrong time zone

(0) Share

Report

Posted on by roxy1

195

Hi,

I am wanting to update a SharePoint List Column (Date and Time format) in my correct time zone when a task has been completed.

In my flow my expression runs correctly, and the output is the correct time and date when the flow runs.

However, when I look at the actual SharePoint List the date and time revert the incorrect time which did not match the output of the flow!

I have also checked my site regional settings and they are correct so I cannot figure out what is going on!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

grantjenkins 11,063 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Can you try the following expression to convert the date to Perth time zone.

//This will convert the date to Perth Timezone convertFromUtc(triggerOutputs()?['body/completedDateTime'], 'W. Australia Standard Time') //Or just try your date direclty which is likely what will get you the correct date in your SharePoint List triggerOutputs()?['body/completedDateTime']

Was this reply helpful? Yes No
roxy1 195 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi again @grantjenkins !

I've tried both those options, the flow indicates it's the correct time but still SharePoint list column the time is off.

For examples:

Not sure if this helps but this is the column settings for the SharePoint List:

Was this reply helpful? Yes No
roxy1 195 on at

Like
a
(0)

Report
Copy link

Link copied!

If anyone stumbles across this I've still had no luck!

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Have you looked at the regional settings applied to the SharePoint site to ensure they're what you expect. Site settings > Regional settings.

Was this reply helpful? Yes No
roxy1 195 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @grantjenkins , yes regional settings are all correct:

Was this reply helpful? Yes No
Verified answer

roxy1 195 on at

Like
a
(1)

Report
Copy link

Link copied!

This is now working in the right time zone, my IT department may have changed some admin settings as I have not changed anything else since!

Was this reply helpful? Yes No