I have two columns in a SharePoint list: Amount and USD Rate.
They are Number columns set to 2 decimal places with the thousand separator. (But Schema debugging shows SharePoint is storing them as integer)
I want to set up a flow to update another Number (or Currency) column called USD Amount Flow.
This column will be populated by the figure derived from dividing Amount by USD Rate.
I have tried many formulas for the Compose action input, but I keep getting the error message that the input is not being converted to a number/double format.
E.g. Compose inputs:
div(float(triggerBody()?['Amount']), float(triggerBody()?['USD Rate']))
float(concat(triggerOutputs()?['body/Amount']) / concat(triggerOutputs()?['body/USD Rate']))
json(string(float(triggerOutputs()?['body/Amount']) / float(triggerOutputs()?['body/USD Rate'])))
float(triggerOutputs()?['body/Amount']) / float(triggerOutputs()?['body/USD Rate'])
E.g. error messages:
Action 'Update_item' failed: The 'inputs.parameters' of workflow operation 'Update_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/USDAmountFlow' is required to be of type 'Number/double'. The runtime value '"div(float(triggerBody()?['Amount']), float(triggerBody()?['USD Rate']))"' to be converted doesn't have the expected format 'Number/double'.
I have created multiple Compose actions to force conversion to number, but nothing has worked.
In the Update Item action, when I hardcode the USD Amount Flow field to say 100, the flow is successful, so it would seem that the problem is not with SharePoint, but with how Power Automate is handling the output of the Compose formulas.
I've been on this for 24 hours (not kidding)
What's the problem?
Thanks.
