How to Fix Excel Dates Not Transferring to SharePoint in Power Automate
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.

- 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.
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.
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.
Navigate to Power Automate, open your specific flow in Edit mode, and locate the 'List rows present in a table' Excel action.
Click on 'Show advanced options' (or 'Advanced parameters') at the bottom of the Excel action card.
Locate the 'DateTime Format' dropdown field and change the value from 'Serial Number' to 'ISO 8601'.
Save your flow and run a test. The dates should now transfer to SharePoint in the correct format without requiring complex mathematical expressions.

Use Power Automate Expression to Convert Serial Dates
If you cannot change the Excel connector settings, use the addDays expression to manually convert the Excel serial number into an acceptable SharePoint date format.
Convert Dates to Text within Excel
Format the dates in Excel as standard text before running the flow, forcing Power Automate to read them as standard date strings.
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. Download and Install: Visit the official WPS website to download and install the free WPS Office suite on your device.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your .xlsx file to view and format your date columns natively.
- 3. Export and Integrate: Save your standardized data seamlessly for smooth integration into web lists and databases.

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.




