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 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