Unanswered

Conditional Expression "AddHours" Error

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have created a flow that pulls from a planner daily to check for any 'overdue' tasks. An overdue task is a task that has not been marked completed by 48hours.

I have the flow check daily at 5am for any uncompleted task, and then a condition that does a comparison to an Array CreatedDateTime. This CreatedDateTime is what I am "greater than or equal" to addHours.

I do not work with expressions often. This is the error message I got:

InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '1' and column '2938': 'The template language function 'addHours' expects a timestamp as the first parameter, the number of hours to add as the second parameter, and an optional format string as the third parameter. The function was invoked with '1' parameter(s). Please see https://aka.ms/logicexpressions#addhours for usage details.

Any assistance, in correcting this would be greatly appreciated... please see flow below.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Hi!

Can you share the details from your current addHours() expression?

Please also note in your Filter array you added what seems to be a WDL expression on the right side of your condition rule as a regular text, meaning Power Automate will not consider it an WDL expression.

If you are unfamiliar with WDL expressions, please follow these steps to add them:

https://youtu.be/LPZ-WZoWwp4

Thanx!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

My current addHours expression is 47. As, I just want it to add 47hrs to the date-time created. But as I play with the expression, I realized thats not how it worked and then broke it.

Was this reply helpful? Yes No