Power Automate: sum(field1, field2, field3, field4) is greater than 0.Easy?

The requirement is to summarize 4 number field values to determine if the total is greater than 0. What could possibly go wrong?

You think it should be somewhere in the Expression under Math functions. Think again.

The add only allows to summarise 2(!?) numbers. Not 3, not 4. It let me to add extra fields and passed the validation then it failed on a run.

The solution is to use Increment Variable 3 times. We Initialize variable with one of the fields then add another 3 fields in the sequential Increment variable actions.

Easy!

Actually, for this specific case when the actual sum is not important and the only thing we care about is the total is greater than 0 it’s enough to determine that at least one of the field values is greater than 0.

Instead of this:

we will have this:

Posted in , ,

One response to “Power Automate: sum(field1, field2, field3, field4) is greater than 0.Easy?”

  1. Power Automate: sum(field1, field2, field3, field4) is greater than 0.Easy? - 365 Community Avatar

    […] Power Automate: sum(field1, field2, field3, field4) is greater than 0.Easy? […]

    Like

Leave a comment