I have a workflow that keeps crashing at the same spot and I can't figure out why.
I inserted "log to workflow history" after every single action and it looks like the "Calculate..." action is the culprit. Please help!
_______________
My list called "Process Steps" is a series of steps that must run in order each month. Every list item begins with a default status of "Not Started."
Changing the status to "In Progress" or "Completed" triggers other workflows which are set to automatically run when an item is changed, with conditions to make sure it fires on the right items.
Workflow 1 is a manual intitation whose purpose is to kick off the process for the month, and will only ever run on the first step (the "Kick off" step). Let's say the ID of the Kick Off step is 100. This WF also contains a variable called "ID number of next step".
To produce the value for this variable, I have this action:
then Calculate Process Steps:ID plus 1 (Output to Variable: ID number of next step)
So- since the ID of Step 1 is 100, the result I am looking for is the value 101.
I need this value to be available later in Workflow 1 to use in the "Update item in ___ list" action, where I tell the item whose ID matches my variable (the next consecutive step ID, 101 in this case) to update its status to "In Progress."
That status update triggers a second workflow designed to run when an item changes, that then fires off its own set of actions, one of which calculates the ID of the next item, and so on and so on, so that each time a step's status is changed from In Progress to Completed, the next consecutive step is initiated by calculating the next consecutive ID number and updating the matching list item's status.
The step that keeps failing is the very first Calculate step in Workflow 1. Is it not possible for a value produced by the 'Calculate...' workflow action to be used as a list ID variable?
Is there a better way to make sure my steps are firing in order?
