web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Subtract from SharePoi...

Power Automate

Answered

Subtract from SharePoint column unless greater than 0

(0) Share

Report

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:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Paulie78 8,422 Moderator on at

Like (1)

Report
Copy link

Link copied!
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
Copy link

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

Join the conversation