Task Completed Date and Time in wrong time zone

[roxy1]

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!

[grantjenkins]

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

[roxy1]

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:

[roxy1]

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

[grantjenkins]

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

[roxy1]

Hi @grantjenkins , yes regional settings are all correct:

[roxy1 · Accepted solution]

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!