I have built a fairly complex flow that works like a champ but had to originally break it up into 2 separate flows because of the need to merge pdf's. My company has now subscribed to the Adobe pdf services connector so I'm trying to automate what previously was a manual process.
The flow is an approval process that sends an invoice to 1 or 2 approvers for review/comment/approval. When the invoice is finally approved the flow creates an "approval" sheet using an html template (which is then converted into a pdf document) and sends a notification that the file has been created and can now be merged with the original invoice. A user must then open the original invoice file, insert the approval sheet, then kick off the 2nd part of the flow (which sends the merged file to an accountant for payment).
I inserted the Merge PDFs action after the steps in which the approval sheet is generated, but no merge occurs. The approval sheet still gets generated correctly but it doesn't get merged into the original invoice file. I'm sure my expression is off somewhere, but since the flow isn't creating any errors I don't know where the flow is failing.
Merged PDF File Name - fileName (this is pulled from a previous Get file properties and is the name of the original invoice file).
Files File Content - 1 - pulled from the pdf approval sheet created by the flow.
Files File Content - 2 - pulled from the original invoice pdf.
So big picture of the flow:
Invoice pdf uploaded to SharePoint library.
Manual Invoice Approval flow started.
Invoice sent to person noted as Approver 1 (waits till it gets a response).
When Approver 1 approves, checks for Approver 2 if none, generates approval sheet and sends notice to merge files.
If there is an Approver 2, invoice is sent (waits till it gets a response).
When Approver 2 approves, generates approval sheet and sends notice to merge files.
I'm trying to eliminate the need to manually merge the approval sheet with my original invoice file. If I can get this sorted then I can add in my second manual flow of sending the approved merged file to an accountant to pay.
Not sure what other parts of my flow I should post to assist, so please feel free to ask. Thank you!
