SharePoint Created column incorrect from Power Automate (Clock change)

[Sam12]

We have renamed the default "Created" column to "Order Date/Time" and have built a Flow that (amongst several other things) updates the Title field of the SharePoint list item to contain the value of the Order Date/Time (Created) field. Up until the clock change a couple of weeks ago this was working fine. However, now there is an hour mismatch between the Title field and the actual Order Date/Time field.

Does anyone know how I can fix this? Ideally I am looking for a permanent fix so we don't need to update this twice per year when the clocks change. Screenshots below:

Power Automate:

[Expiscornovus · Accepted solution]

Hi @Sam12,

Flow will use the UTC time, that's why you are seeing a time difference in the title column.

Can you a convert to time zone to set it to your preferred local time. Below is an example.

In the update item I am using this expression for the Title column:

concat('FX-', body('Convert_time_zone'))

[Sam12]

Thanks @Expiscornovus!

Is there any advantage to using the expression you used above, over adding the below?