Answered

Send email based on condition from Forms result

(0) Share

Report

Posted on by XavierMas

Based on a submitted reply from Forms, I'd like an email to be automatically sent if the result is greater than a constant.

I've followed the steps from other posts but I am still getting this error message " Unable to process template language expressions for action 'Condition' at line '1' and column '2794': 'The template language function 'greater' expects two parameter of matching types. The function was invoked with values of type 'String' and 'Integer' that do not match.'".

Thanks for your help.

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (1)

mobeenmohsin on at

Like (0)

Report

Hi,

This seems to be data type mismatch issue, please use expression as below:
https://docs.microsoft.com/en-us/power-automate/use-expressions-in-conditions#use-the-greater-expression

We can parse the value using function in expression as below:
https://docs.microsoft.com/en-us/power-automate/use-expressions-in-conditions#use-the-greater-expression

Casting has been discussed as below:
https://powerusers.microsoft.com/t5/General-Power-Automate/Casting-string-to-integer/m-p/38398#M10237

Please mark the answer if solved your problem.

Best Regards,

Mobeen Mohsin

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

Hi!
My suggestion is to use int() based expression on the left side of your condition to transform your forms 'Temperature' output into an integer
If it stoll does not work, then do the opposite: use int() based expression on the right side of your condition to transform 37.0 into an integer
Hope this helps

Was this reply helpful? Yes No
XavierMas 18 on at

Like (0)

Report

Thanks for your help, but it tells me that my value cannot be converted 🤔

When I enter "@greater(int(triggerBody()?['Temperature']), 37)", it returns:

InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '1' and column '2795': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

Hi!
My suggestion is: add a dummy Compose action block just before your Condition, assign is its input:
triggerBody()?['Temperature']

reexecute flow. It will fail again, but please inspect and share Compose content.
Thanx!

Was this reply helpful? Yes No
XavierMas 18 on at

Like (0)

Report

There it is

Was this reply helpful? Yes No
XavierMas 18 on at

Like (0)

Report

I am not sure I did that right...

If I select "Temperature" in compose as below

I am getting the following result:

Was this reply helpful? Yes No
XavierMas 18 on at

Like (0)

Report

I am making more progress, the flow is running now when using "Outputs" from compose.

However the logical test (greater than 37) is acting weird, it returns the following:

"2" it returns false,
"36.7" it returns false
"37.1" it returns true

but

"4" or "5"... etc until "9", it returns true as if the logical test was only on the first number

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

Hi!

@XavierMas wrote:

I am making more progress, the flow is running now when using "Outputs" from compose.

However the logical test (greater than 37) is acting weird, it returns the following:

"2" it returns false,

"36.7" it returns false

"37.1" it returns true

but

"4" or "5"... etc until "9", it returns true as if the logical test was only on the first number

THe current problem is... Compose seems to have transformed your form input into a string, so your condition is now comparing two strings... Integer 4 is lower than 37, but string '4' is greater than string '37'.

On your flow design, can you please hover the mouse over the dynamic content you currently have assigned as input to Compose and send me the screenshot with its value?

Thanx!

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

Hi again

It is my fault, I suggested to use int() but we need to use float() instead.

More info un a couple of minutes

Was this reply helpful? Yes No
XavierMas 18 on at

Like (0)

Report

Thanks for your help

here's the detail:

Was this reply helpful? Yes No