Answered

Compose subtract from a variable

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am currently building a flow, where I need to help myself with some "flags" and I like to use numbers to see the status.

Now when I am doing the "month countdown" my flow runs each week and if the value is still not 0 it should continue to substract until the value is 0 each week.

So, I am trying to achieve this by having Initializing Variable which is equal to some value from SharePoint, let's say 4. And then I need to write a formula that would do something like sub(@{variables('HelpVariable1')},1), but I am not really sure if I am getting the syntax right. I did not fully understand it yet and any guide, how to write formulas would be really useful.

Thanks in advance.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-litu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous,

There is no sub() function in Flow, but you could use add() function to achieve it.

So, it could be add(variables('HelpVariable1'),-1)

But it seems like you want to value it back to variable HelpVariable1, so maybe you could have a try that using Decrement variable action, put the 1 into it, it will sub 1 to itself:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @v-litu-msft ,
thanks for your reply.

I will definitely give it a shot, but according to this post and many others sub() expression should be in flow, even the expression builder offers it in it's "intellisense".
https://powerusers.microsoft.com/t5/General-Power-Automate/How-do-I-substract-two-values-from-sharepoint-column/m-p/88728#M12894

I will let you know with results 🙂 Thanks.

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

Sorry, no sub() function is a flash in my head, as a matter of fact, there is.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No