web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Task Completed Date an...

Power Automate

Answered

Task Completed Date and Time in wrong time zone

(0) Share

Report

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:

I have the same question (0)

All responses Img

All responses (6)

Answers Img

Answers (1)

grantjenkins 11,063 Moderator on at

Like (0)

Report
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 (0)

Report

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 (0)

Report

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

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

Like (0)

Report

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 (0)

Report

Hi @grantjenkins , yes regional settings are all correct:

Was this reply helpful? Yes No
Verified answer

roxy1 195 on at

Like (1)

Report

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

Join the conversation