How to add an attachment to an email vial script

[Mark94]

Hi,

I have a workflow, that having done bits and bobs creates a PDF file, and attaches it to the ticket (a purchase order ticket). The next step I have been asked to build is to attach that PDF to an email and send it externally.

I've tried one method which was detailed in another post -

Attempt 1 -

1. Go to System Notification > Email > Notification Email Scripts
2. Create email script called 'attachfile'
3. Add this line to the script -    
template.print('Attachment: <a href="sys_attachment.do?sys_id=b32dec79db2dd450c646f5461d9619d6">Attachment</a>');
4. Add the following line to the workflow's Notification step in the message -
${mail_script:attachfile};

Sadly, this only adds a link to the PDF, and doesn't attach it to the email (I hard coded the sys_id only as a test).

Attempt 2 -

I've started to create a script inside the workflow. This was again taken from another post.

var gr = new GlideRecord('sys_attachment');
  var table = '';
  gr.addQuery('table_sys_id',current.instance);
  gr.query();
  while(gr.next()) {
      table = gr.table_name;
  }
  if (table != '') {
      GlideSysAttachment.copy(table,current.instance,'sys_email',current.sys_id);
      gs.print('Creating attachment');
  }
 

I've now got a bit stuck, I'm not sure where to go from here. This in itself isn't doing anything, and I'm not sure if it's going to. Can anyone point me in the right direction. Am I on the right track?

Many thanks,

Mark.

[SW7]

Mark,

Please take a look at the screenshots I created of get attachment and send email. Please let me know if this helps, or I will step you through the simple one we created.

Kind regards

Steve

[Mark94]

Hi Steve,

I'm so nearly there. The flow has picked up the attachments with the "Get Attachments on Record" step, but in the "Send Email" step, I can't find a way to attach them to the email being generated. Is that step 5.4 in your flow? If so, could you expand that bit please.

Thank you for all your help so far.

Kind Regards,

Mark.

[SW7 · Accepted solution]

Mark,

Excellent, yes please see the attached for 5.4 & 5.41 which shows the setup.

Please let me know once this is working, otherwise please feel free to show your setup and happy to compare.

Kind regards

Steve

[Mark94]

Woohoo! That's done it. Thank you. It's weird that the attachment step comes after what I thought was the step to send the email. I would have thought that the email had already been sent... but it works!

That's great. Thank you for all your assistance and patience.

Kind Regards,

Mark.

[SW7]

Mark,

No problem at all, glad that you had success. I absolutely love Flow Designer and the possibilities are endless. 

Kind regards

Steve