cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Greater Than Condition Expects Two Parameters?

I've created a form, with 1 field being numbers. In Flow, I want to any value > 150 to trigger a notification. However, it fails at the Condition with:

 

InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '1' and column '2726': 'The template language function 'greaterOrEquals' expects two parameter of matching types. The function was invoked with values of type 'String' and 'Integer' that do not match.'.
 
I'm sure this is an elementary mistake. I can confirm the field sourced is definitely a number. For visual reference, please see below.
 
Capture.PNG
1 ACCEPTED SOLUTION

Accepted Solutions

Hi @EddyGee 

 

Thanks for the update. I did built one and yes you were missing the apply each loop.

 

In my example below Question 3 is the numeric value.

 

form1.png

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

View solution in original post

15 REPLIES 15
Super User III
Super User III

Hi

 

Try the following:

 

1. Add a compose and map the value above the condition step.

2. Then in the condition map use the expression int(outputs('Compose'))

 

If the above doesn't work please post a screenshot of our runtime history



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Community Support
Community Support

Hi @EddyGee ,

 

Have you take a try with @abm 's solution?

Please take a try and the flow should as below:

1.png

The expression in the first field of the condition as below:

int(outputs('Compose'))

Please let me know if your problem could be solved.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-alzhan-msft  / @abm 

 

Thanks for the response, apologies for the delay.

 

I tried that before actually, & got the following:

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

Hi @EddyGee 

 

Thanks for your reply. Could you please post a screenshot of your flow runtime history?



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

Apologies, not sure how that's done @abm - looking into it.

Do you just mean that?

RunScreen.PNG

Could you please post the compose run history? So that I can see what value it's coming through. Also I need a design screenshot of IF condition?



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

Like this? (input/output link look dead)

 

design.PNGcompose.PNG

However, when not entering the "variable" that's > 150 in the Condition part, instead just inserting it into an excel row, it displays the value entered on the form (i.e. 400 in this case), so 400/'a number' is coming through.

Hi 

 

Thanks for the screenshot. So what is the type of this  Microsoft Form field?



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

Bog standard number input

 

Gift.PNG

I've also tried inputing into excel then citing that as the checker, but got another error.

The solution involves both the aforementioned examples by @abm & @v-alzhan-msft  in addition to appling a "Apply to each" control grouping.

Hi @EddyGee 

 

Thanks for the update. I did built one and yes you were missing the apply each loop.

 

In my example below Question 3 is the numeric value.

 

form1.png

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

View solution in original post

Community Support
Community Support

Hi @EddyGee ,

 

Have your problem been solved?

If yes, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (73,034)