Skip to main content
Community site session details

Community site session details

Session Id : sn+84zZPB/8bP6CLGhQ2ZO
Power Automate - Building Flows
Answered

Condition less than value using dynamic data

Like (0) ShareShare
ReportReport
Posted on 9 Jan 2020 14:24:55 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

 

 

  • Verified answer
    Community Power Platform Member Profile Picture
    on 09 Jan 2020 at 15:51:27
    Re: Condition less than value using dynamic data

    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

  • abm abm Profile Picture
    32,506 Most Valuable Professional on 09 Jan 2020 at 15:09:37
    Re: Condition less than value using dynamic data

    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

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

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Loading complete