Amey Holden

View Original

Format Dates in Power Automate: the lazy (ABC) way!

You format dates in Power Automate, that’s probably not new news. Every single time I come to date formatting in my flows I find myself googling, fiddling with formula and always left thinking ‘this should be easier’. There is lots of handy documentation and blog posts out there on how to do it[1] but I want to show you a lazy, ABC (anything but code) way to do date time formatting and calculating in your flows. In this case I had a Date only field that had come from a document flow in SharePoint, I needed to add a time to it for creating an Event record in Dynamics Marketing.

Happy anything but coding!

[1] formatDateTime formula cheat sheet - https://sharepains.com/2018/11/12/formatdatetime-flow-power-automate/