Others

Fix Microsoft Lists Displaying Dates Differently from Form Responses

Amos GikundaAmos Gikunda Oct 13, 2026 870 views

Question details

Dates submitted via Microsoft Forms and processed by Power Automate are displaying differently in the Microsoft Lists main view compared to the item details.

How to Fix Microsoft Lists Displaying Dates Differently from Form Responses
Product
Microsoft Lists
Device & OS
not provided
Scenario
A user is using a Power Automate flow to create Microsoft List items from Microsoft Forms responses and notices a date display mismatch in the list view.
Observed behavior
The date appears correctly within the specific item details and the underlying SharePoint list, but displays differently or incorrectly in the Microsoft Lists view.
Before you start

Verify your Microsoft Lists column settings and ensure that your regional date and time configurations match your Power Automate flow setup before proceeding.

Solution 1Recommended

Verify Column and Regional Settings in Microsoft Lists

Ensure the display discrepancy is not caused by a simple regional formatting mismatch or an incorrectly configured column type.

Before escalating the issue to Microsoft Support, it is crucial to rule out basic configuration errors. Sometimes, the site's regional settings do not align with the time zone used by your Power Automate flow.

1
Check Column Settings

Open your Microsoft List, click the dropdown arrow next to your Date column header, select 'Column settings', and choose 'Edit'. Ensure the type is strictly set to 'Date and time'.

2
Verify Site Regional Settings

Click the gear icon (Settings) in the top right corner, select 'Site information', and click 'View all site settings'. Under 'Site Administration', click 'Regional settings'.

3
Match Time Zones

Ensure the selected Time Zone matches the time zone configured in your Microsoft Forms and Power Automate flow environment to prevent date-shifting.

Verify Column and Regional Settings in Microsoft Lists
Power Automate Default Time: Power Automate flows process dates in UTC by default. If your flow does not include a 'Convert time zone' action, the date might shift by a day depending on the time of submission.
Free Microsoft Office alternative

Try WPS Office for Seamless Data Management

While waiting for Microsoft Support to resolve your list syncing issues, consider using WPS Office for your daily productivity needs. It offers a lightweight, highly compatible alternative for spreadsheets, documents, and presentations.

  1. 1. Download WPS Office: Visit the official WPS website and download the free installation package for your device.
  2. 2. Install the Software: Run the installer and follow the on-screen instructions to set up WPS Office on your system.
  3. 3. Manage Data Easily: Open WPS Spreadsheet to import, edit, and export your data with perfect date and time formatting compatibility.
Free, lightweight, and fast-loading office suite.High compatibility with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Familiar user interface requiring zero learning curve.Built-in PDF editing and powerful data formatting tools for reliable data display.
microsoft office alternative - wps office

Frequently Asked Questions

Why is the date correct in SharePoint but wrong in Microsoft Lists?

Microsoft Lists uses a different rendering interface than the classic SharePoint Online list view. Occasionally, backend UI syncing issues cause Microsoft Lists to display date formats incorrectly despite the underlying SharePoint data remaining accurate.

Can Power Automate time zone settings cause this discrepancy?

Yes. If your Power Automate flow processes data in UTC but your Microsoft Lists site operates in a local time zone, the date might visually shift by a day depending on the exact time the form was submitted. Using a 'Convert time zone' action in your flow can prevent this.

What is a HAR log and why does Microsoft Support need it?

A HAR (HTTP Archive) log records the network communication between your web browser and the Microsoft Lists server. Support teams use this file to identify exactly where the data translation or rendering fails during the page load.