Sending Attachments via Flow from Submitted Catalog Item

Steven McCray1
Giga Guru

Greetings,

Scenario: I have a catalog item leveraging a flow, this catalog item, when submitted, will have variable fields and attachments on the record itself (RITM) that need to be emailed (via flow) to a user.

Everything works, except attaching the files that were attached to the catalog item when it was being submitted.

 

I've reviewed and created the copyAttachment custom Flow action per the links below (the solution provided by Goran Lundqvist), but am still unsuccessful.

 

In the images below, you will see that the copyAttachment action is identical to Goran's provided solution.

Note: I am aware that the original code is on his GitHub, but when I attempted to upload the update set, I was getting conflicts in regards to "Could not find a record in sys_hub_action_type_base for column model referenced in this update set" for varius sys_hub_action_input records, and a singular sys_hub_step_instance record. That didn't stop me from trying to resolve them, but the result was the same as my own manually copied action.

 

Everything looks like it almost works.. I've validated the correct source and target tables are being identified in the flow context, but for whatever reason, the attachment is not being copied over to the sys_email table. The sys_id's match correctly here in the image.

find_real_file.png

find_real_file.png

 

copyAttachment Details

Inputs

find_real_file.png

Script step

find_real_file.png

 

Workflow Details

find_real_file.png

1 ACCEPTED SOLUTION

Maik Skoddow
Tera Patron
Tera Patron

Hi

at https://community.servicenow.com/community?id=community_question&sys_id=6e46dd49db25a3049540e15b8a96... you can see at the comments section a longer thread between Göran and a user. There is also a workaround described.

Maybe that helps.

Kind regards
Maik

View solution in original post

2 REPLIES 2

Maik Skoddow
Tera Patron
Tera Patron

Hi

at https://community.servicenow.com/community?id=community_question&sys_id=6e46dd49db25a3049540e15b8a96... you can see at the comments section a longer thread between Göran and a user. There is also a workaround described.

Maybe that helps.

Kind regards
Maik

Yep, you are correct, somehow I overlooked that, I did look through the comments but I don't know, too late of a night... Anyways, drilling into the Email > sys_id did it. Thank you so much for pointing that out!

 

For others - this is the specific part that fixed my specific issue. The 5 > email is what i had, drilling to the 5 > email > sys_id resolved it.

find_real_file.png