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?

Microsoft Security Windows Autopilot
Microsoft 365 and Office Development Microsoft 365 Publishing
Microsoft Copilot Microsoft 365 Copilot Development
Exchange Licensing
Exchange Other
0 comments No comments
{count} votes

Accepted answer
  1. JimmyYang-MSFT 58,641 Reputation points Microsoft External Staff
    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.