Error in date when item is created in SP LIST

(1) Share

Report

Posted on by angeldiaz96

Hello guys, i hope all well,
I have a simple flow that uses form responses and sends them to a list.

However, the column called FECHA SOBRETIEMPO is a date type and arrives with one day less when it's created.
What could be causing this?

Note: My site has my local time zone set to -5

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Pstork1 69,556 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

When you enter or retrieve dates/times from SharePoint using Power Automate it always uses UNC time (Greenwich mean time) because that is the way it is stored in the backend. but when you retrieve it using SharePoint it will convert it to the local time zone for your SharePoint site. You are inputting 06/14 at midnight in UTC, but since you are 5 hours behind that it will display as 06/13 at 7:00PM in SharePoint.

----------------------------------------------------------------------------------
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
Vish WR 3,748 on at

Like
a
(1)

Report
Copy link

Link copied!

@angeldiaz96

I would recommend converting the date in flow to match your sharepoint site ,

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥

Was this reply helpful? Yes No
Suggested answer

Haque 3,653 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @angeldiaz96,

The date column arrives with one day less is a common timezone or date handling quirk in Power Automate specially when working with date fields from Forms to SharePoint. One of the biggest catch is if the time part is midnight UTC, converting to a timezone behind UTC (e.g., UTC-5) shifts the date back by one day.

Possible wyas to fix this:

Convert the incoming date to a date-only string before writing to SharePoint. Let's use an expression to extract only the date part without time, e.g.:

formatDateTime(triggerOutputs()?['body/FECHA_SOBRETIEMPO'], 'yyyy-MM-dd')// No time

Note: This strips the time and avoids timezone shifts.

Use the date-only string in the SharePoint update or create item action for the date column.

Alternatively, adjust the date by adding a timezone offset if you want to keep time but correct the shift, using addHours() or convertTimeZone() expression. Like:

addHours(triggerOutputs()?['body/FECHA_SOBRETIEMPO'], 5)

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No