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.

All responses (6)

Answers (1)

powernewbie221 8 on at

Like (0)

Report

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

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

Thank you Dezhi 😁
Verified answer

v-dezhili-msft Microsoft Employee on at

Like (0)

Report

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

Hi @powernewbie221 ,

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

Best Regards,
Dezhi
powernewbie221 8 on at

Like (0)

Report

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

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
v-dezhili-msft Microsoft Employee on at

Like (0)

Report

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

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
powernewbie221 8 on at

Like (0)

Report

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

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.'.
v-dezhili-msft Microsoft Employee on at

Like (0)

Report

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

Hi @powernewbie221 ,

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

Best Regards,
Dezhi