July 19, 2024

I’ve used the addSeconds Function in previous posts but never spent time to explain it adequately. This function adds the number of seconds to a specific date, based on a particular format.


It follows a simple pattern.

  1. Date
  2. Number of seconds to add/remove
  3. (Optional) Date Format


addSeconds('2019-10-28T10:10:00Z', 10,'yyyy-MM-ddTHH:mm:ssZ')

will return 


Looks quite straightforward, right? Positive numbers add seconds, and negative exclude seconds.

Please be aware that, in 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).


Contrary to SharePoint and PowerApps, there’s no limitation to the date that you can use. You can do things like:


and you'll get 


They behave like you’re expecting.


  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 hours, minutes, and days, so don’t do any math trying to use the addSeconds Function to add days, for example.
  3. Complementary to addSeconds Function you can also use the addToTime Function. I recommend using addSeconds Function because it makes the formula more readable, but the result is the same.


Microsoft’s addSeconds Function Reference


Back to the Power Automate Function Reference

Featured Image by Agê Barros on Unsplash

Manuel Gomes

I have 18 years of experience in automation, project management, and development. In addition to that, I have been writing for this website for over 3 years now, providing readers with valuable insights and information. I hope my expertise allows me to create compelling, informative content that resonates with the audience.

View all posts by Manuel Gomes →

Leave a Reply

Your email address will not be published. Required fields are marked *