Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Trying to build an approval flow that uses if=or less than value!Ah6GOxsDl4B_owA4RKUqlxlKQHX1Hello,

Trying to build a workflow that uses the value of a condition with the Less Than or = to, as well as if greater than X. For Examaple.


When a SharePoint List is modified, Run Approvals.

Get 0365 info, etc. etc..


But there are two approval Values. 5K-9999.99 and 10K and up. Need to fork the flow to have two different approval routes depending on Field Amount (Field) which will be a dollar amount listed about. 


Anyone have any ideas?


This is a screen shot of what I'm working with. 

Link to Flow Screenshot


Community Support Team
Community Support Team

Re: Trying to build an approval flow that uses if=or less than value

Hi @Rbert83,


I think this cannot be achieved so far in flow as you have 2 condition values, 5K-9999.99 and 10K and up. 

You could post this idea in the Flow Ideas forum, so it might be considered for future releases.



Mona Li

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Level: Powered On

Re: Trying to build an approval flow that uses if=or less than value

Wouldn't I be able to use a "Switch Case"? Instead of doing 5k-9999 maybed if I broke it up and did if = to or greather then 5k. do this. if over 10k do this? That's the only thing I can think the Switch Case is for but not sure how to try it out.

Level: Powered On

Re: Trying to build an approval flow that uses if=or less than value

I know this is an older post but I am working on doing something similar with a Purchase Request list in SharePoint. 


Basicly if the purchase is less than $100 do this, $100 to $1200 do this and greater than $1200 do this. It then looks a a 'Request Type" column and applies it to a switch to then send approvals to the correct people. 


Building the Flow i have When an item is created to trigger the flow. I then have 3 conditions that run in parralel branches with the functionsof 

@less(triggerBody()?['Total'], '$100.00')

@and(greater(triggerBody()?['Total'], '$100.00'),less(triggerBody()?['Total'], '$1200.00'))

@greater(triggerBody()?['Total'], '$1200.00')


The Total filed is calculated off the Qty and Unit Price columns in SharePoint, and is formated to currency with 2 decimals showing.


For what ever reason though it is not working. i have put in values of less $5, $400, and $2000 but it seems like they all go to the Greater than 1200 route. any thoughts as to why?

Helpful resources


Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.


Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,763)