Answered

Sub expression not working in Flow action

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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!

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Expiscornovus 33,768 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
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)

Was this reply helpful? Yes No
AdminofMk 62 on at

Like (0)

Report
Copy link

Link copied!

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.

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

Like (1)

Report
Copy link

Link copied!
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'])

Was this reply helpful? Yes No
AdminofMk 62 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
AdminofMk 62 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No