Hi,
I have an old workflow I'm trying to convert to Flow but I'm having trouble with the calculation. Here is what the workflow does:
It updates a whole number field by 1 when a set of option set fields are set to a certain value. It uses "Increment by" and clears out the field in the beginning so that the calculation is accurate.
I found the add() function in Expressions in Flow so I decided to try using that to increment my whole number field by 1 and also have an update action that is clearing out the field value in the beginning like the workflow did. The problem is, it doesn't know how to account for when someone goes and switches a value more than once on any of the option set fields. When that happens, it throws off the count. The workflow knew how to account for this with the "clear" dynamic value used at the beginning of the workflow, but adding something similar to the beginning of the flow doesn't help.
Is the add() function the best way to handle incrementing values in Flow? And if so, how do I tell it to account for those option set fields getting switched more than once on the same field?