Error Handling within Table Row to Variable Loop Start
Hello,
I’m currently experiencing what I think is a very niche issue. I’m in the process of developing a workflow to dynamically create and populate templates within excel. I’m utilizing the copy excel sheet node from the AF Utility Nodes extension. I’ve noticed some finicky behavior that I’m hoping to fix. When executing the workflow an error message will appear (attached below). I’ve experimented using wait nodes and while that seems to lower the frequency of the error, it still occasionally happens. I’ve even tried to run the workflow with NO other applications open/running and still get the error.
I’ve never used Try Catch nodes but I’m thinking that is where my solution lies. I’ve watched a few videos including https://www.youtube.com/watch?v=zlH8W0lWl_I. This is the desired effect I want, the workflow to re-execute where it left off if there is an error. However, I’ve been unsuccessful in my attempts to achieve it. For one, my loop terminates with a flow variable instead of a table so the Variable Condition Loop End node isn’t an option. Number two, my loop starts with a Table Row to Variable Loop Start node, not a generic loop start.
In summary, I want to automatically “re-execute” the variable loop end node if the excel writer node errors out.
Thanks for any help or suggestions - John