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 / Condition less than va...
Power Automate
Unanswered

Condition less than value using dynamic data

(0) ShareShare
ReportReport
Posted on by

Hi everyone, 

 

I'm a bit stuck on creating a flow which should use a condition with following: if 'total' [calculated column in library] < 50000.

The column uses numbers.

 

Ideally if true, then an e-mail is sent to person A if not an e-mail is sent to person B.

 

I found some other posts, but they used edit in advanced mode, and even when I used their expression on the left side and then equals to true, the expression is deemed not valid.

I also tried Total [dynamic data] is less than 50000, but doesn't work. Maybe I should change something to the 50000? 

 

Can someone help with this condition? Thanks in advance!

Best regards,

Laura

 

 

Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,865 Most Valuable Professional on at

    Hi Laura,

     

    Try convert the total to int or float and compare. If not map the total amount to a compose action and check the compose output to compare in your IF statement.

     

    Let me know how it goes.

     

    Thanks

  • Verified answer
    Community Power Platform Member Profile Picture
    on at

    Hi@abm 

     

    Thanks for your help.

    I figured out the issue, I forgot to add quotes to the value, which is why the expression wasn't working since I had two different types of variables. 

     

    Best regards,

    Laura

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 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard