web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Automated email notifi...
Power Automate
Unanswered

Automated email notification based on score received on Microsoft Form

(0) ShareShare
ReportReport
Posted on by

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:

  1. When a new response is received, pull that response into an Excel Spreadsheet on SharePoint (no issue here)
  2. 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:
I have the same question (0)
  • Verified answer
    trad Profile Picture
    152 on at

    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.

  • rebeccas Profile Picture
    2,591 on at

    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. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard