07-31-2020 01:42 AM
A common issue I’ve run into and that I’ve heard others experience, is trying to use Excel DateTime values in Power Automate. You will encounter an error like below:
The reason this is an issue is due to the way Excel stores dates and times:
Thus, an excel datetime value can be represented as ddddd.tttttt
For example, the if the current date and time is 27 July 2020 15:20:54, it would be represented in Excel by the value 44039.63951.
If you wished to work with that date in Power Automate you would encounter an error.
This Flow converts the Excel Serial to it's representative DateTime value. The Flow includes a Scope that breaks the steps in the expression down in to their component steps to enable understanding, but they are all included in a single Compose action at the end of the Flow. This expression can be copied to any other Flow for utilisation
You can read more about this Flow on my blog