Unanswered

Subtract from SharePoint column unless greater than 0

(0) Share

Report

Posted on by sobenson

169

I am writing a flow that if someone changes a "status" column a second "priority" column will subtract 1 from the current value. I am using the expression:

sub(outputs('Update_item_2')?['body/on0o'],1)

and it works, however I don't want to to go below zero.

I tried this, but it says my expression is invalid

if(triggerOutputs()?['body/on0o']>0,(sub(triggerOutputs()?['body/on0o'],1)),)

Any suggestions?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Paulie78 8,422 Moderator on at

Like (1)

Report
Re: Subtract from SharePoint column unless greater than 0

if ( greater(variables('number'),0), sub(variables('number'),1), 0 )

See how you get on with that instead, I think your exact expression would be:
if ( greater(triggerOutputs()?['body/on0o'],0),(sub(triggerOutputs()?['body/on0o'],1)),0 )
But you will have to check your end.

Please...
If I answered your question Accept it as a solution ✔️
If I helped you out, please give me some Kudos 👍
Thanks 😙

Was this reply helpful? Yes No
sobenson 169 on at

Like (1)

Report
Re: Subtract from SharePoint column unless greater than 0

Hi @Paulie78 , thank you!
You had one to many () in the sub statement in the example you copied of my info, (your example statement was correct) but this worked great! Thanks!

This was the final working version
if(greater(triggerOutputs()?['body/on0o'],0),sub(triggerOutputs()?['body/on0o'],1),0)

Was this reply helpful? Yes No