Answered

Flow with currency fields Cancel with No Inputs

(0) Share

Report

Posted on by cmegow

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.

I have the same question (0)

All responses (11)

Answers (2)

Expiscornovus 33,175 Most Valuable Professional on at

Like (0)

Report

Re: Flow with currency fields Cancel with No Inputs

Hi @cmegow,

Can you share the output of the update item action of one of the flow runs which got cancelled? It is interesting to see what the value of the fields was before the condition action.

Was this reply helpful? Yes No
cmegow on at

Like (0)

Report

Re: Flow with currency fields Cancel with No Inputs

@Expiscornovus Here is the last test run information.

And, just so you can see it...here is the Update Item action:

Was this reply helpful? Yes No
cmegow on at

Like (0)

Report

Re: Flow with currency fields Cancel with No Inputs

@Expiscornovus any thoughts on why this condition may not be receiving inputs?

Was this reply helpful? Yes No
Expiscornovus 33,175 Most Valuable Professional on at

Like (0)

Report
Re: Flow with currency fields Cancel with No Inputs

Hi @cmegow,

Apologies that I missed your earlier reply. Your configuration looks ok.

What I would suggest to troubleshoot this is to place three compose actions just before your condition and try the three expressions below.

int(triggerOutputs()?['body/Invoice_x0020_Amount'])

int(outputs('Update_item')?['body/Open_x0020_PO_x0020_Value'])

equals(int(triggerOutputs()?['body/Invoice_x0020_Amount']), int(outputs('Update_item')?['body/Open_x0020_PO_x0020_Value']))

Was this reply helpful? Yes No
Ellis Karim 11,651 Super User 2025 Season 2 on at

Like (0)

Report
Re: Flow with currency fields Cancel with No Inputs

Can you try comparing the Invoice Amount and Open PO Value both taken from the trigger "When an Item is created".

left: int(triggerOutputs()?['body/Invoice_x0020_Amount']) right: int(triggerOutputs()?['body/Open_x0020_PO_x0020_Value'])

right: int(outputs~~('Update_item')~~?['body/Open_x0020_PO_x0020_Value'])

Ellis

Was this reply helpful? Yes No
Verified answer

cmegow on at

Like (0)

Report

Re: Flow with currency fields Cancel with No Inputs

@Expiscornovus thanks for the suggestion. I added the three compose formulas as suggested and ran a test. The first 2 ran, but the third was skipped. This time it shows the condition as skipped no inputs instead of cancelled no inputs. That's one step in the right direction!

Was this reply helpful? Yes No
Expiscornovus 33,175 Most Valuable Professional on at

Like (0)

Report

Re: Flow with currency fields Cancel with No Inputs

Hi @cmegow,

Thanks for testing that. What values did you see in the Compose and Compose 2 actions. The values you were expecting?

Can you also make a screenshot of the left branch in that flow run, interested what type of actions you are using there.

Was this reply helpful? Yes No
cmegow on at

Like (0)

Report

Re: Flow with currency fields Cancel with No Inputs

@Expiscornovus thank you so much for your thoughts...

Here is my left condition. I simply sends an email to notify out accountant that an invoice has been logged. The condition allows me to put my name in to prevent the email being triggered so I can test the Flow.

The outputs were just as expected. I also tried updating the third compose formula with the dynamic content from my first 2 compose functions without success. I also tried changing my Condition to compare the results of Compose and Compose 1 without success. That resulted in Skipped no input.

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,175 Most Valuable Professional on at

Like (0)

Report

Re: Flow with currency fields Cancel with No Inputs

Hi @cmegow,

I think your condition action is skipped because of your terminate action. It probably terminates the flow before your actions in the other branch are executed.

Can you temporarily remove that terminate action and test it again without that action?

Was this reply helpful? Yes No
cmegow on at

Like (1)

Report

Re: Flow with currency fields Cancel with No Inputs

@Expiscornovus that was it. I feel so silly. I can just leave the terminate function out. I only had it there so I could easily see that the email flow was off...goodness. Thanks! The flow is working just fine now. THANK YOU for helping me trouble shoot.

Was this reply helpful? Yes No