How to use an Excel Date Integer in Power Automate

AdministrationAdminCustomizations
Written By Matt Peacock

If you’re trying to use an Excel file within Power Automate, you may have noticed something funky with the dates. Power Automate will read the date as an integer not the actual date as it was formatted in Excel.

No worries though - here’s how you can solve that.

Applies to:

  • Dynamics 365 On-Prem

  • Dynamics 365 On-line

  • Power Automate

Excel stores its dates as the number of days since 1899-12-30. So in order to convert the integer to a date, we need to add that integer to the date (1899-12-30).

In this example you can see the date returned from the Excel table is an integer of 44060 - so that means that the date needed is 44060 days since 1899-12-30.

We’re going to add a COMPOSE step to do some work on it.

And we’ll set the compose value to be the following formula

addDays('1899-12-30',int( <DATE FIELD>),'yyyy-MM-dd')

Next we can use that output from the compose step in future steps

 

Photo by Pixabay:

Related Content:

Matt Peacock
Previous

How can I use Power Automate to sum child record values in Dynamics 365?
Next

Column Types in Dynamics 365