How to create a condition in Power Automate using numerical values

User116218 20 Reputation points
2024-03-12T09:32:15.4733333+00:00

I have created a flow that retrieves data from an Excel file with columns named 'Name', 'Mail id', and 'Percentage of Completion'. I have set a condition where, if the percentage of completion is less than or equal to 50, an email with the 'Body1' content (if yes (condition))should be sent to the person else send the (if no) body content. However, the flow is not working properly. Even if the percentage is less than or equal to 50, the same content is passed on. Here is my workflow and condition:
User's image

User's image

User's image

User's image

Can someone tell me why this is happening?

Windows Autopilot
Windows Autopilot
A collection of Microsoft technologies used to set up and pre-configure new devices and to reset, repurpose, and recover devices.
407 questions
Microsoft 365 Publishing
Microsoft 365 Publishing
Microsoft 365: Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line. Publishing: The process of preparing, producing, and releasing content for distribution or sale.
595 questions
Microsoft Exchange
Microsoft Exchange
Microsoft messaging and collaboration software.
389 questions
Microsoft Copilot for Microsoft 365 Development
Microsoft Copilot for Microsoft 365 Development
Microsoft Copilot for Microsoft 365: Microsoft 365 Copilot refers collectively to Copilot experiences within Microsoft 365 applications.Development: The process of researching, productizing, and refining new or existing technologies.
52 questions
Microsoft Exchange Licensing
Microsoft Exchange Licensing
Microsoft Exchange: Microsoft messaging and collaboration software.Licensing: Rules, regulations, and restrictions that define how software can be used and distributed.
7 questions
0 comments No comments
{count} votes

Accepted answer
  1. JimmyYang-MSFT 48,871 Reputation points Microsoft Vendor
    2024-03-13T07:21:49.78+00:00

    Hi @User116218

    Exchange tag is mainly focused on the gerneral issue of Exchange Server troubleshooting. According to your description, your question is more related to Power Automate flow. The following suggestion is just for your reference.

    Based on my research, your condition is not right. The following picture shows for your reference:

    User's image


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


    1 person found this answer helpful.
    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. User116218 20 Reputation points
    2024-03-14T05:03:43.6133333+00:00

    solved the issue, thanks!

    0 comments No comments

  2. User116218 20 Reputation points
    2024-03-15T06:46:32.5833333+00:00

    solved the issue, thanks!

    0 comments No comments