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
Dyn365CE31 March 2021Finding Records Shared With a Specific Team or User
Dyn365CE14 October 2020Calculate Full Months between two dates with Power Automate
Dyn365CE3 August 2020Converting UTC Date Time to UNIX Time with Power Automate
Dyn365CE28 July 2020Converting Excel Date Time Serial Values With Power Automate
