I'm building a flow for purchase orders.
The user starts at an MS Form. Fills it out, and adds the total to a line we'll call "Total for Purchase" as that's the name of the field.
When they hit submit, it goes to a flow.
The idea is, when it hits the flow, it creates the SharePoint list item.
So far, this works perfectly, easy, done.
Hold on there, cowboy! It's not that easy!
You see, we're now at the point where I need to add the right people to get the approval. I have variables set up, easy money. Add a drop-down in the form per department, it checks the submission and adds the people.
So far, this works perfectly. Easy. Done.
Not so fast, chief!
This is where things start breaking down.
You see, there is a thing in our business process where if it's over X amount, it goes to person a and person b. And if it's over XX amount, it goes to person a, b, and c.
So I created a condition to look at the above-mentioned "Total of Purchase" field in the Sharepoint entry, and then append the needed peoples.
But that's where it really breaks apart. Because for whatever reason, it only looks at the FIRST number in the total, not the whole total.
So:
LOW - 0-1500 = no appended peoples
MID - 1500-5000 = people A & B
HIGH - 5000+ = people A, B, & C
So, if I put the total for 256.14, it SHOULD go to 'LOW' in the lame table above. But it goes to MID. Why? Because 256.14 starts with the number 2. It's .. alphabetizing? Sorting starting with the first number and .. that's it? I'm so confused.
Originally the Sharepoint List has that column as "Currency". I changed it to number to test it, and no.
I've tried comparing the value directly to the field "Total of Purchase' but also create a variable, just in case it needed it to be changed to an integer or something smart. But that didn't work.
I'm kind of at my wit's end. Any help or insights or random blessings would be super appreciated.
And because my message isn't long enough already, here are shots of my three checks:
