Fix Microsoft Lists Displaying Dates Differently from Form Responses
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.

- 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.
Verify your Microsoft Lists column settings and ensure that your regional date and time configurations match your Power Automate flow setup before proceeding.
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.
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'.
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'.
Ensure the selected Time Zone matches the time zone configured in your Microsoft Forms and Power Automate flow environment to prevent date-shifting.

Submit a Support Ticket to Microsoft
If basic settings are correct, this is likely a backend syncing issue in Microsoft Lists that requires administrative escalation and investigation.
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. Download WPS Office: Visit the official WPS website and download the free installation package for your device.
- 2. Install the Software: Run the installer and follow the on-screen instructions to set up WPS Office on your system.
- 3. Manage Data Easily: Open WPS Spreadsheet to import, edit, and export your data with perfect date and time formatting compatibility.

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.




