Power Automate Excel Connector Dates
When you have a Power Automate which needs to extract dates from an excel spreadsheet, and email them out or update a SharePoint list, the imported data is returned as plain numbers instead as dates, even though the cells themselves are formatted as dates.
For example the date 06/18/12 is being read in as 41078. So, how to solve it?
That pretty easy to transform it:
addDays('1899-12-30',int(items('Apply_to_each')?['Date']))
Note: There’s a reason to use 1899-12-30 and not 1900-01-01. For some reason, when using 1900-01-01, flow is adding two more days to the expected result.
More Info
List of all supported available connectors for Microsoft Power Automate here.
Ready to enhance your Power Automate experience?
Contact us for:
- Intranet and Portals: Personalized solutions just for you.
- Application Development: Intuitive, scalable, and secure solutions.
- Consultancy Services: Expert advisory solutions.
- Outsourcing: Maximize productivity.
- Support and Maintenance: Keep your applications running seamlessly.
If you are interested in learning more about us and how we can help you, contact us.
You can also check out our blog for more articles and insights on Microsoft 365 technologies.