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:
- Dates are stored as a number representing the number of days since 1900-01-00
- Times are stored as a fractional portion of a 24 hour day
Thus,…
Continue Reading ryanmaclean365’s Article on their blog
Converting Excel Date Time Serial Values With Power Automate
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: Dates are stored as a number representing the number of…
Blog Syndicated with ryanmaclean365’s Permission
More About This Author
Array
Dyn365CE2021.03.31Finding Records Shared With a Specific Team or User
Dyn365CE2020.10.14Calculate Full Months between two dates with Power Automate
Dyn365CE2020.08.03Converting UTC Date Time to UNIX Time with Power Automate
Dyn365CE2020.07.28Converting Excel Date Time Serial Values With Power Automate
