Announcements
Hello,I have an Excel Online table that I want to add Dates to a Sharepoint List, but I can only pass 2 items, not all of them.
How can I solve that?
Is the date in the Excel workbook stored in Excel's serial date format? If so, you may need to convert it before adding days. Perhaps.
Hi @jedunn
That's how it is.
In the two error items are in Date format in Excel Online.
I found the following post that may help you:
There are also some folks posting on other sites about how to do this. I found some useful information while searching 'flow convert excel date to datetime'.
It looks like the common solution is to add an expression to the create item action
I used the following expression but you can make this more robust to missing/empty values with some if conditions in the expression.
addDays('1899-12-30', int(item()['Date']), 'MM-dd-yyyy')
Hi @jedunn,
How would be the expression that indicates?
To make it more resistant
You would use an if statement to check for null values in the date item. Because I'm still learning I don't know how to do that with expressions but this article might be a place to start... Handling Excel Dates in Microsoft Power Automate (shanebart.com). There might be other helpers on the forum with previous tips for constructing if statements.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 573
Valantis 407
11manish 387
