I have encountered an issue when an app has submitted several independent row changes resulting in multiple triggers of a Workflow. The short of it is that it seems the updated row is reset to its original state at the time the changes were made when each trigger instance is processed. For example, I have boolean flags that the Workflow sets to TRUE in an attempt to additional triggers of the same Workflow on the same row. But when the next workflow trigger is processed, this row value is set back to unassigned.
The data changes to the same row made during workflow processing DO NOT stay. However, processing to any OTHER rows during workflow processing DO stay. This creates an inconsistent state of the data between execution instances. In my case, calculations end up performed multiple times when only once is desired.
I have uploaded a video to YouTube to help with understanding of the issue I see.
Video:
The tester app (link below) works like thisโฆI have a sheet named Calculation which holds result values. Each is identified by a Code. I enter in the Main sheet a record that indicates a Code and value to be subtracted from the result. When the record is saved, that generates 1 workflow trigger. I have added an Action on the Save function that simply sets Flag1 to TRUE and then resets it back to FALSE. This generates 2 additional workflow triggers.
When the Workflow is processed, it sets a flag StopFutureProcessing? in an attempt to prevent any additional updates from occurring for this row, it performs the calculation subtracting the entered value from the result and then sets a Calculated? flag to try and prevent additional calculations from happening.
I am finding, because the row reset to original state, Workflow triggers 2 and 3 are processed and the calculation is performed 3 times.
Please post any questions or requests needed for further clarification.
App:
https://www.appsheet.com/start/e676fd64-7ec9-4231-a30b-33dbe153ed24
LinkedIn
Twitter
