Date time format

(0) Share

Report

Posted on by GMANE

Hi there, I am running a flow between power apps and sharepoint with the help of powerautomate. For some reason when i fill out the hour field in my app, sharepoint saves the time 1h ahead. I've tried so many ways to fix the problem but the time still shows 1h ahead. I went to the sharepoint list settings, I have chagned the formula in powerautomate using the following formula and more, but still the correct time does not show. Does anyone know how to fix this issue?:

concat(
formatDateTime(convertTimeZone(triggerBody()?['date'], 'Central Europe Standard Time', 'UTC'), 'yyyy-MM-dd'), 'T',
string(triggerBody()?['text_3']), ':',
string(triggerBody()?['text_4']), ':00Z'
)

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

lbendlin 8,598 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Is there an actual issue? You should always be using UTC dates in all your processes. That's how data is stored in the PowerPlatform and elsewhere in Azure. Preferably ISO-8601 format (which you have)

Was this reply helpful? Yes No
Suggested answer

Pstork1 69,024 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Adding the 'Z' at the end of your string makes the system assume that this is UTC time, but you've manually converted it to Central Europe time, which is UTC+1. The connector in Power Automate is expecting UTC time, but you are giving it a UTC time that is one hour off. Remove the conversion and you will be working with UTC and it should then be correct.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No