SharePoint Document Issues

How to Fix SharePoint Dates Showing One Day Earlier in Power Automate

Amos Gikunda Oct 23, 2026 868 views

Question details

Users need to correct a date mismatch where dates submitted via Microsoft Forms are recorded as one day earlier when populated into a SharePoint list using Power Automate.

Fix SharePoint Dates Showing One Day Earlier in Power Automate

Product: Power Automate & SharePoint
Device & OS: not provided
Scenario: Using a Power Automate flow to extract data from a Microsoft Forms submission and create a new item in a SharePoint list.
Observed behavior: The date value submitted in Microsoft Forms correctly displays in email notifications, but appears exactly one day earlier in the corresponding SharePoint list.

Before you start

Verify the exact time zone settings configured in your Microsoft 365 account, your SharePoint site's Regional Settings, and the user profile running the flow to identify any immediate mismatches.

Solution 1Recommended

Use the 'Convert Time Zone' Action in Power Automate

Explicitly convert the UTC date-time from Microsoft Forms to your local time zone before inserting it into SharePoint.

Power Automate processes dates in UTC by default. When a date-only value from Forms is sent at midnight UTC, converting it implicitly to a local time zone that is behind UTC rolls the date back to the previous day.

Open the flow editor

Log into Power Automate, select your flow, and locate the step where the Microsoft Forms response is retrieved.

Add a time conversion step

Click to add a new action before your 'Create item' SharePoint action, and search for 'Convert time zone'.

Configure the time zones

Set the 'Base time' to the date field from your Forms response. Set the 'Source time zone' to Coordinated Universal Time (UTC) and the 'Destination time zone' to your local time zone.

Update the format string

In the 'Format string' field, select 'yyyy-MM-dd' to ensure only the date is passed through without the time.

Update the SharePoint action

In the 'Create item' action, replace the original Forms date dynamic content with the 'Converted time' output from your new step.

Use the 'Convert Time Zone' Action in Power Automate

SharePoint column setting: Ensure your target column in the SharePoint list settings is set to 'Date Only' rather than 'Date and Time' to prevent further rendering shifts.

Solution 2

Use an Expression to Format the Date Manually

Directly format the date string using a formula expression inside the SharePoint action to discard problematic time data.

Free Microsoft Office alternative

Looking for a simpler way to manage your documents?

While complex automated workflows in cloud ecosystems can sometimes lead to frustrating time zone and formatting glitches, managing your everyday local and cloud documents shouldn't be a hassle. Try WPS Office, a powerful, lightweight, and free alternative that seamlessly handles your document needs without the headache.

1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
2. Install the software: Run the installation file and follow the quick on-screen instructions.
3. Open and edit: Launch WPS Office and open your existing Office documents directly to start working.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight design ensures fast installation and smooth performance without bloatware.Built-in PDF editor and comprehensive toolkit for everyday productivity.Familiar user interface requires zero learning curve to switch seamlessly.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my SharePoint list date show as 10:00 PM the day before?

This happens because SharePoint lists often interpret incoming date-only values as midnight (12:00 AM) UTC. If your regional site setting is UTC-2 or further behind, the displayed time rolls back to the previous calendar day.

Do I need to change my SharePoint Site regional settings?

Yes, it is highly recommended. Navigate to Site settings, click Regional settings, and ensure the Time Zone correctly matches the primary location of your users. Mismatches here are a common cause of date shifts across Microsoft 365 apps.

Can I fix the Power Automate dates without using the 'Convert time zone' action?

Yes, you can use expressions directly within the dynamic content field, such as addDays() or formatDateTime(), to manually offset the time or force a specific date format before inserting the data into SharePoint.

Document & File Issues