addHours function(Power Automate Cloud flows)

Japanese version.

Adds the specified number of hours to the date and time.

Although not an unnecessary function, it is sufficient to unify date calculations with addToTime.


timestampRequired fieldSpecify the date and time of the calculation source.
hours Required fieldSpecifies the number of hours.
Positive values calculate in the future direction; negative values calculate in the past direction.
formatyyyy-MM-ddTHH:mm:ss.fffffffKSpecifies the format of the result.

How to use

In most cases, it is used in the "value" when initializing or setting variables of type "string".

Click on the "Expression" tab, addHours, and the function name and () will be set in the expression field.

If you want to use dynamic content or variables, the ,delimiter is the same.

(How to get dynamic content with expressions.)

Click on the OK button, and if the display looks like the following, the setting is complete.

You can change the function by clicking this purple icon.

For example, addHours('2022-01-02T14:00:00',1) would result in January 2, 2022 at 15:00.

If it can be recognized as a date, it will be calculated in other formats as well.

If you want to change the format of the result, specify the format in the third argument.



Date and time Functions(Power Automate Cloud flows)