Answered

My condition will no register my Microsoft forms answer as a number. Help please?

(0) Share

Report

Posted on by powernewbie221

Hello,

I have tried to add a condition into my flow basically if the number of hours entered (this is is number format in the form) is between 8 and 32 I want it to trigger an approval. I have tried converting it with string as seen in the image below but this does not work.

I have entered 9, 11, 20 into the form and the condition reads as false.

Any help would be much appreciated.

I am also very new to Power Automate so very basic level explanation would be much appreciated.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @powernewbie221 ,

Please try convert them both to integer with int().

Best Regards,
Dezhi

Was this reply helpful? Yes No
powernewbie221 8 on at

Like (0)

Report
Copy link

Link copied!

Hi Dezhi, how do I do that?

I changed it to this and this is the error message I received.

InvalidTemplate. Unable to process template language expressions for action 'Condition_3' at line '0' and column '0': '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.'.

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @powernewbie221 ,

Sorry for not being clear.
What you need to do is convert the output of the trigger to an integer.

Best Regards,
Dezhi

Was this reply helpful? Yes No
powernewbie221 8 on at

Like (0)

Report
Copy link

Link copied!

Hi Dehzi,

The form is not a drop down it is a free type but number only, does that make a difference?

I have changed both to integer

The flow failed, it says no outputs

Was this reply helpful? Yes No
Verified answer

v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @powernewbie221 ,

This doesn't matter, as long as your output is in a numeric format.

Best Regards,
Dezhi

Was this reply helpful? Yes No
powernewbie221 8 on at

Like (0)

Report
Copy link

Link copied!

OMG it worked!! Thank you so much for your help I was stuck on that yesterday for hours!

Thank you Dezhi 😁

Was this reply helpful? Yes No