Unanswered

Date time format

(0) Share

Report

Posted on by GMANE

So to answer @Pstork1 and @lbendlin, I have written both formulas in both ways in powerautomate, but sharepoint still saves the time 1h ahead. I've also tried to change the time to 03:00 for example in powerapps, but the sharepoint list still saves it as 04:00. Any idea of what else could be wrong?

concat(

formatDateTime(triggerBody()?['date'], 'yyyy-MM-dd'), 'T',
string(triggerBody()?['text_3']), ':',
string(triggerBody()?['text_4']), ':00Z'
)
 
concat(
formatDateTime(triggerBody()?['date'], 'yyyy-MM-dd'), 'T',
string(triggerBody()?['text_3']), ':',
string(triggerBody()?['text_4']), ':00'
)

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @CU06110921-0,

Does the time you are updating in Sharepoint via power automate is of UTC format ?

Was this reply helpful? Yes No
Ellis Karim 11,695 Super User 2025 Season 2 on at

Like (0)

Report
Hi @CU06110921-0

I encountered similar questions back in October and wrote a blog post about it.
SharePoint STORES dates in UTC. I am referring to the use of the Date type column in SharePoint.

A "Z suffix" at the end of a date-time string indicates UTC, example: 2024-10-05T08:15:34Z.

Your first concat() expression contains the Z suffix indicating UTC.

concat( formatDateTime(triggerBody()?['date'], 'yyyy-MM-dd'), 'T', string(triggerBody()?['text_3']), ':', string(triggerBody()?['text_4']), ':00Z' )

In your second concat() expression there is no Z suffix. Without the ‘Z’ suffix, SharePoint would interpret the date-time based on the site’s configured time zone (for example in an OData filter query inside a Get Items action).

You could simplify both of your expressions to:

formatDateTime(triggerBody()?['date'], 'yyyy-MM-ddT00:00Z') formatDateTime(triggerBody()?['date'], 'yyyy-MM-ddT00:00')

The SharePoint site itself DISPLAYS dates based on to the site’s Regional settings.

Power Automate READS dates from SharePoint in UTC.

Power Apps DISPLAYS the date and time based on the PC’s local time zone settings, which may cause different users to see different local times for the same date.

See: Why Are My SharePoint Dates Wrong in Power Apps and Power Automate? – Ellis Karim's Blog

Ellis

https://elliskarim.com/

Was this reply helpful? Yes No