In a flow I'm working on, I have two currency columns that I need to compare. I have a condition that compares the Input of the "When Item is created: Invoice Amount" to the "When Item is Updated: Open PO Value". I thought it should be simple to compare two currencies with the float() or int() expression, but I'm getting a cancel message that the condition is receiving no inputs
The flow is triggered by "When Item is created" in my SharePoint List using a Power App.
'Invoice Amount' is a currency column and the user inputs the amount into the Power App.
'Open PO Amount' is a currency column and the value is calculated using variables in the Power App. This parts works just fine.
The first action in my flow is 'Update Item' and it updates the column 'Open PO Value' to the value captured by the Power App calculations for 'Open PO Amount'. I use this number in subsequent flows and to calculate items entered in the future.
My next step in the flow is the failing condition.
The parallel branch is a email condition that works fine.
Here are my expressions in the failing condition
left: int(triggerOutputs()?['body/Invoice_x0020_Amount']) right: int(outputs('Update_item')?['body/Open_x0020_PO_x0020_Value'])
I've also tried just comparing the dynamic content fields. I've tried float(), and I've tried using the original calculated value from my Power App with the following right side condition: int(triggerOutputs()?['body/Open_x0020_PO_x0020_Amount'])
Nothing has worked. I keep getting "No Input" as the message in my cancelled condition.
Thanks for your time to help.
