How we can copy attachment from incident table to problem table field of type 'File Attachment'?

[PrashantLearnIT]

How can we copy an attachment from the incident table to the problem table field of type 'File Attachment'?

[Shivalika]

Hello @PrashantLearnIT 

In flow designer its very easy - 

1)First use Get All Attachment OOB Action with source record as your incident. 

2)Then use For each - Look Up record in the "sys_Attachment" table with sys_id as - what obtained in get all Attachments

3)Add if condition on the "content-type" field whatever you want

4)Then use Copy attachment - again source as "for each" and target will be problem record. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

[PrashantLearnIT]

Hi @Shivalika 

I cannot use the flow designer, as I am using the record producer. An attachment attached to the record producer catalog item and submission will add an attachment to the custom table in one of its fields (File Attachment as its field type),the flow designer will not work here

[Shivalika]

Hello @PrashantLearnIT 

What's the issue then, I have a whole flow designer running for record producer and custom table. 

Then create the trigger like - record created - table as your custom table. 

Now your attachments are stored in produced records table - Get all the attachments from here. 

Look up attachment in sys_attachment table - again goes same 

Did you try this out ? 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

[PrashantLearnIT]

i am not creating any record just adding attachment to target table field of type File Attachments