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:
Solved! Go to 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'))
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'))
Thanks @Expiscornovus!
Is there any advantage to using the expression you used above, over adding the below?