Answered

Sub expression not working in Flow action

(0) Share

Report

Posted on by Community Power Pla...

Afternoon all

I've got a Flow where I'm trying to subtract the value from a field called 'Qty' in one list from a value in a field called 'Test qty' in a different as shown below:

However expression isn't subtracting the values. This is the output from the tests I've run:

Where am I going wrong? All help appreciated!

All responses (5)

Answers (1)

AdminofMk 62 on at

Like (0)

Report

Re: Sub expression not working in Flow action

Hi @Expiscornovus ,
Thanks for your effort to help me out, i found the solution. below expression works perfectly.
AdminofMk 62 on at

Like (0)

Report

Re: Sub expression not working in Flow action

Hi @Expiscornovus ,
i double checked, the field was in number format only,
also i have tried the expression as your suggest, still same error occurs.
Expiscornovus 31,641 Most Valuable Professional on at

Like (1)

Report
Re: Sub expression not working in Flow action

Hi @AdminofMk,

It looks like your Remaining Leave field is text. Try and convert it to a decimal or a number.

Try something like:

sub(float(outputs('Get_a_row')?['body/Remaining Leave']), triggerBody()['number'])
AdminofMk 62 on at

Like (0)

Report

Re: Sub expression not working in Flow action

HI @Expiscornovus ,
I want to subtract a value from a excel table and subtract with the flow input then i need to update the excel table with the output from subtraction. i tried a flow but its giving me some error can you help me out please.
Verified answer

Expiscornovus 31,641 Most Valuable Professional on at

Like (1)

Report
Re: Sub expression not working in Flow action

Hi @Anonymous,

Can you remove the single quotation mark characters around the Qty and Test qty variables in your expression?

It will think you are trying to subtract strings instead of integer or float values. using the sub function for strings is not supported. This should work:
sub(0,20)