I have a form that allows employees to submit a funds request that updates a SharePoint list, via a flow. That kicks off another flow that submits for approval, the request. It works, but I have two minor glitches.
- The form submission has an "amount requested" field that applies to a currency field in the list. When someone decides to fill out the field in currency format $400.00 instead of 400.00, the flow fails and I get and error about number/double expected, which I understand but I can't find a way to convert their input to the number I need.
- The second flow works pretty well but again when the amount is submitted for approval, even though it's a currency column in the list, it is submitted as just a number with no decimals, ie $400.00 from the list is 400 in the approval request.
I have tried everything I can find and poured over help posts from 2017 to present. Nothing I try resolves. Any help would be immensely appreciated.
