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!

All responses (6)

Answers (1)

Verified answer

roxy1 195 on at

Like (1)

Report

Re: Task Completed Date and Time in wrong time zone

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!
roxy1 195 on at

Like (0)

Report

Re: Task Completed Date and Time in wrong time zone

Hi @grantjenkins , yes regional settings are all correct:
grantjenkins 11,059 Super User 2025 Season 1 on at

Like (0)

Report

Re: Task Completed Date and Time in wrong time zone

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

Like (0)

Report

Re: Task Completed Date and Time in wrong time zone

If anyone stumbles across this I've still had no luck!
roxy1 195 on at

Like (0)

Report

Re: Task Completed Date and Time in wrong time zone

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:
grantjenkins 11,059 Super User 2025 Season 1 on at

Like (0)

Report
Re: Task Completed Date and Time in wrong time zone

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']