Data Import & Export

How to Fix Excel Dates Not Transferring to SharePoint in Power Automate

Kushani NimanthikaKushani Nimanthika Nov 2, 2026 870 views

Question details

User needs to resolve an issue where date values from an Excel spreadsheet fail to transfer or populate correctly into a SharePoint list when running a Power Automate flow.

How to Fix Excel Dates Not Transferring to SharePoint Using Power Automate
Product
Excel, Power Automate, SharePoint
Device & OS
not provided
Scenario
Automating data transfer from an Excel table to a SharePoint list using Microsoft Power Automate.
Observed behavior
Excel dates appear as 5-digit serial numbers (e.g., 44197) in SharePoint, or the flow fails entirely due to a format mismatch with the SharePoint date column.
Before you start

Ensure your Excel file is saved in an accessible cloud location like OneDrive or SharePoint, the data is formatted as a recognized Excel Table, and the target SharePoint column is strictly set to the 'Date and Time' type.

Solution 1Recommended

Configure 'DateTime Format' in the Excel Action

Adjust the advanced settings of the Excel connector in Power Automate to automatically output dates in ISO 8601 format instead of raw serial numbers.

By default, Power Automate reads Excel dates as raw serial numbers (the number of days since January 1, 1900). The easiest way to fix this is by telling the connector to return the date as a standard ISO string, which SharePoint natively understands.

1
Open your Power Automate flow

Navigate to Power Automate, open your specific flow in Edit mode, and locate the 'List rows present in a table' Excel action.

2
Show advanced options

Click on 'Show advanced options' (or 'Advanced parameters') at the bottom of the Excel action card.

3
Change DateTime Format

Locate the 'DateTime Format' dropdown field and change the value from 'Serial Number' to 'ISO 8601'.

4
Save and test

Save your flow and run a test. The dates should now transfer to SharePoint in the correct format without requiring complex mathematical expressions.

Configure 'DateTime Format' in the Excel Action
Best Practice: Using the ISO 8601 setting in the connector is the most reliable method and avoids the need for manual formula conversions in later flow steps.
Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

Dealing with complex Excel date serials and integrations can be tedious. WPS Office provides a lightweight, highly compatible, and free alternative to Microsoft Office, ensuring your data is formatted correctly without the hassle. It flawlessly supports .xlsx formats and offers an intuitive UI for managing large datasets.

  1. 1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite on your device.
  2. 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your .xlsx file to view and format your date columns natively.
  3. 3. Export and Integrate: Save your standardized data seamlessly for smooth integration into web lists and databases.
100% compatible with Microsoft Excel (.xlsx, .xls) and CSV files.Easily format, clean, and export date columns without serial number errors.Lightweight software that runs smoothly on Windows, Mac, and Linux.Completely free to use with a familiar, easy-to-navigate tabbed interface.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Automate read my Excel date as a 5-digit number?

Excel stores dates internally as serial numbers representing the number of days since January 1, 1900 (e.g., 44197). Power Automate reads this raw serial data by default instead of the visual date format applied in the spreadsheet.

What is the correct date format for SharePoint lists?

SharePoint strictly requires dates to be in the ISO 8601 format (such as YYYY-MM-DD or YYYY-MM-DDTHH:mm:ssZ) when receiving data via Power Automate integrations.

How do I handle time zone differences when transferring dates?

You can use the 'convertTimeZone' expression in Power Automate or the 'Convert time zone' built-in action to adjust the UTC time output by Excel to your SharePoint site's local time zone before creating the item.

Why does my Power Automate flow fail with a String to DateTime conversion error?

This happens when the SharePoint Date column receives an empty string or a non-date value (like text or an unconverted 5-digit serial number) from Excel. Use a condition action in your flow to check for empty values, or use the if(empty(...)) expression to handle blank cells appropriately.