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.
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.
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.
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
@and(greater(triggerBody()?['Total'], '$100.00'),less(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?
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!