Answered

Automated email notification based on score received on Microsoft Form

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Good day!

I am trying to build a flow for a Microsoft Form for a quality audit process. The form has branching based on the type of audit being completed (4 types total). I am trying to accomplish the following primary tasks:

When a new response is received, pull that response into an Excel Spreadsheet on SharePoint (no issue here)
When a new response is received where one of the score variables is lower than a threshold (.8), send an automated email to the quality team.

Link to what it looks like currently

I receive the following error:

Unable to process template language expressions for action 'Condition' at line '1' and column '27628': 'The template language function 'lessOrEquals' expects two parameter of matching types. The function was invoked with values of type 'String' and 'Integer' that do not match.'.

I'm new to this and appreciate any insight! Happy to provide additional context if necessary.

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

trad 152 on at

Like (0)

Report
Copy link

Link copied!

Sounds like these score values are being returned form the form as strings, which is the default for example if you are getting these scores from a "choice" input type in a form.

It's a bit unclear to me why it would say the second value is an integer, since "0.8" is a float, but at any rate you can cast your form response to a float to allow the comparison to work with an expression like float(outputs('Get_response_details')?['body/r1234567890....']) in the left hand side of the comparison.

Was this reply helpful? Yes No
rebeccas 2,591 on at

Like (0)

Report
Copy link

Link copied!

I have had a similar error before on something with SharePoint. What I did is forced my value to be a number by using int(). I just used the Expression and put int(<Here I clicked on the field from my content>)

I don't use excel much in Flow but this might work for your scenario too. That was the same error I had.

Was this reply helpful? Yes No