+9The users are filling an Input start Form on NWC with attachments.
we want to generate a PDF into document template from the filled form and append the attachments provided on the form to the generated PDF as one document before sending it to the users to approve.
We are able to use docgen to generate the pdf from the form data. But can someone help and explain how can we merge the attachment files? detailed steps will be appreciated.. new to NWC.
Thank you!
Best answer by leighburke
@cmikhaiel_e So you will need to count the number of files, then conditionally extract the files from the collection by checking against the number of files(See Below). You will then need use the same condition to include the file in your document generation. Here is an export key for a quick sample(RKJsQWzLjz8fp5DWWSCXARPDBeqPcw4dGTmKtzyyPvfTnbtbt), you would add a condition up to the maximum number of files.
@cmikhaiel_e So you will need to count the number of files, then conditionally extract the files from the collection by checking against the number of files(See Below). You will then need use the same condition to include the file in your document generation. Here is an export key for a quick sample(RKJsQWzLjz8fp5DWWSCXARPDBeqPcw4dGTmKtzyyPvfTnbtbt), you would add a condition up to the maximum number of files.
+4@kbarton Here is the workflow again, so you can see my example I made(RKJsQWzLjz8fp5DWWSCXARPDBeqPcw4dGTmKtzyyPvfTnbtbt). You get each file out of the collection and put it in it's own variable. Those are then conditionally merged if they exist in the Document Generation action.
+4@kbarton you need to know the maximum number of files, you can also make the file being merged conditional on the collection count.
@leighburke can you please send your workflow key, I am unable to open the workflow using the key in the tread.
I am trying to merge several pdfs users will be attaching in the form as one document and then place a signature in that attached document package.
Thanks in advance for your help!
+9@leighburke I am interested in this solution. But what do these shared export keys mean? (khEHTFjQaiyYCHdNs7MoYNPSMMFZK7fdqy13GkzUp1SV2gkLr) How does this bring me to the sample workflow?
Hi @WouterT,
I have changed the export link to the following(RKJsQWzLjz8fp5DWWSCXARPDBeqPcw4dGTmKtzyyPvfTnbtbt), we have a nice video explaining how to import and export workflows(https://www.youtube.com/watch?v=fC2SDnQHEvE).
+9Thanks @leighburke for your quick reply! I am going to study this for sure. Wasn't aware of this feature. I asked this actually in the context of this SharePoint Online List Attachment problem I just posted here.
+1Hi @leighburke ,
I have created the WF as per your imported version. I have allowed for up to 10 files but when I tested the WF the instance failed with the message being " ! Index was outside the bounds of the collection". Looks like it failed at attempting to check for attachment number 9 and the form only had 8 attachments? The run if actions were configured like yours with the index being greater than a certain number?
@EleanorK That error looks like the 'run if' ran when it shouldn't I would check the condition and confirm the collection size using a log in details. Keeping in mind the last index value will be 1 less than the count because collections start at 0.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
