Ok, so this one is kind of complicated/hard to explain. So bear with me.
I have an app setup with one hand-off/workflow.
I created a Zap triggered by a new GoCanvas Submission and I have "trigger mid workflow" checked 'yes'.
The first step in the zap uses google sheets "find or create a row" "Lookup Row", and "create a new row if that row doesn't exist" is selected.
Upon the 'mid workflow hand-off' the app/zap triggers a row to be created and a bunch of information (including a status remark "sent to supervisor for approval") is added to the row (I do not add the pdf link). The "lookup row function" identifies the assigned "GoCanvas Submission No." in order to identify/flag that 'row id' for a later step in the zap.
Just after this step, I have a filter deployed that only allows the zap to continue if a field that can only be filled in after the hand-off is completed. In other words, the app can never continue after this point until the final submission is completed.
Re-cap, So the app has been handed-off to the next user, a row of information has been added to the sheet by the mid workflow trigger, and the row id is flagged for a later step.. Hope that makes sense up to this point.
Upon final completion/submission of the second part of the app (after the workflow), the zap triggers again, the first part does essentially nothing because the row has already been created and now it passes through the filter because the condition was met, then it gets to an "Update Spreadsheet Row" step. This step adds/updates the additional information (from after the hand-off) to the row previously created/identified in step 2 and it also adds the link the created for the Designer PDF to the sheet.
Here's where my problem occurs, I then have a step to add/rename and create the PDF file in Google Drive.
Everything works exactly as it should, however, as long as I have "trigger mid workflow" selected, the PDF linked in the spreadsheet and the PDF placed in Google Drive are missing all of the information from after the workflow hand-off.. The fields are blank.
If I leave everything exactly like it is, and uncheck the 'trigger mid workflow' and wait for the zap to be triggered/PDF created upon final submission, the PDF created contains all of the information as it should.
It seems when "Trigger mid workflow" is checked, a PDF is created during the first workflow hand-off and no matter what is added/changed afterwards, that original PDF is the one you get.
Even if I have a completely separate zap built to create the PDF upon final submission, as long as "trigger mid workflow" is selected on the other zap, the PDF is missing the information.
This also occurs if someone re-opens an app using the "History" tab inside the mobile app, edits, and re-submits. The zap triggered email attachment, and/or one placed in Google Drive is the same PDF file from before the edits and does not show the updates.
The problem seems to be, that when the final app is submitted, the older PDF/link (created during the hand-off) should be overwritten but that is not happening.
Even if I have a completely separate zap built to create the PDF upon final submission (nothing to do with work-flows), as long as "trigger mid workflow" is selected on the other zap, the PDF will be missing the information.
Is this something I am doing wrong/missing?