Power Automate: addMinutes Function

Power Automate: addMinutes Function

by: Manuel ⏱️ 📖 2 min read 💬 0
The addMinutes Function works just like the addSeconds Function and other similar functions. It adds the number of minutes to a specific date, based on a particular format.

Usage

It follows a simple pattern.
  1. Date
  2. Number of minutes to add/remove
  3. (Optional) Date Format
Example:
addMinutes('2019-10-28T10:10:00Z', 10,'yyyy-MM-ddTHH:mm:ssZ')

will return 

'2019-10-28T10:20:00Z'
Looks quite straightforward, right? Positive numbers add minutes, and negative excludes them. Please be aware that the reference material, Microsoft names objects like '2019-10-28T10:10:00Z' as timestamps. I prefer calling them “Date” to avoid confusion with the UNIX timestamp, commonly used in APIs, to represent the number of seconds elapsed since Jan 01 1970 (UTC).

Limitations

Contrary to SharePoint and Power Apps, there’s no limitation to the date that you can use. You can do things like:
addMinutes('1000-12-30T00:00:00Z',10,'yyyy-MM-ddTHH:mm:ssZ')

and you'll get 

1000-12-30T00:10:00Z
They behave like you’re expecting.

Recommendations:

  1. Always include the format, even if the value is optional. The default value is “yyyy-MM-ddTHH:mm:ss:fffffffK” but the date provided may not be stored in the same format and will return either wrong times or errors. You can define a single format specifier (for example “o”) or a custom format pattern (for example “yyyy-MM-dd”) so pick your favorite, but be sure to define it.
  2. There are analogous functions for days, hours, and seconds, so don’t do any math trying to use the addSeconds Function to add minutes, for example.
  3. Complementary to the addMinutes Function, you can also use the addToTime Function. I recommend using the addMinutes Function because it makes the formula more readable, but the result is the same.

Sources:

Microsoft’s addMinutes Function Reference Back to the Power Automate Function Reference. Featured Image by Nikita Burdin on Unsplash

Comments

💬

No comments yet

Be the first to share your thoughts on this article!

Leave a Comment

Comments are moderated before appearing 5000 chars left
Replying to