Greater than and less than condition requirement

[Anonymous]

Currently I have a MS Form where questions are answered on a 1-5 rating scale. I am looking to build a simple flow whereby answers that are greater than 3 are viewed as positive and delivered a certain email, and those that are less than or equal to 3 are negative. 

I am sure that this is a simple flow, but any advice on how to set this up would be much appreciated. 

[kdavis91]

@Anonymous ,

I would suggest creating a Flow that uses a MS Forms Trigger and then uses the Condition action block to test if the response of a given question is less than 4, then you can use the "Yes" branch to send the desired email.

If you need help with a specific piece of a flow that you're building, be sure to ask after first attempting to make it work on your own.

thanks,

Kyle

[Anonymous]

This should work,

[Anonymous]

Hi Kyle,

Currently i have set up the following:

However that is bringing up this error message:

Thanks very much

[kdavis91]

@Anonymous ,

insert a "Compose" action block after "Get Response Details" and pass in the dynamic content that you're trying to evaluate in the Condition. This will return the value of that content.

In order for the "greater than" condition to be evaluated, both of the parameters need to be the same data type, and it looks like PA is saying that dynamic content is a string while "3" is an integer. Determining what the value of the other parameter is will inform us on how to proceed.

thanks,

Kyle

[tom_riha · Accepted solution]

Everything MS Forms sends into Power Automate is in a 'string' format. If you want to compare it with a number, you must convert one side of the condition, either the data from the Forms into a number or the right side of the condition into string. The easiest way is to put ' ' around the number to convert it into a string.