If you have been following my posts on SharePains.com, then you will know about the UTCNow function generating the current UTC time. But did you know that there is a hidden parameter that comes with this function?
The UTCNow Function
Table of Contents
One of the Date and time functions in Power Automate is the UTCNow.
And as we use the UTCNow function the intellisense offers the syntax to be used to us. So UTCNow doesn’t have any parameters. But…
Examples of UTCNow
In the below flow I’ve created a few examples of UTCNow with a formatString added as a parameter.
yyyy/MM/dd : @{utcNow('yyyy/MM/dd')}
hh:mm : @{UtcNow('hh:mm')}
No Parameters: @{utcNow()}
With the above three expressions we get the following output returned.
For all the options available to format the UTCNow output I recommend reading my post about the formatDateTime function.
Discover more from SharePains
Subscribe to get the latest posts sent to your email.
Pieter Veenstra
Is your business still running on paper trails, sprawling Excel files, or ageing Access databases? There's a better way — and I can show you exactly what it looks like. I'm the Technical Director of Vantage 365, a Microsoft solutions consultancy working with clients across the UK, the Netherlands, and worldwide. For over 30 years I've been turning messy, manual business processes into clean, automated systems that save time, reduce errors, and give teams the visibility they need to make better decisions. SharePains is not just any blog run by a Microsoft MVP. Have you ever used Try-Catch in Power Automate? The original post about Try-Catch in Power Automate can still be found on this site, https://sharepains.com/2018/02/07/try-catch-finally-in-power-automate-flow/ Or have you ever used the Pieter’s method to avoid variables and speed up your flows? https://sharepains.com/2020/03/11/pieters-method-for-advanced-in-flows/ You can contact me using contact@sharepains.com