SOLVED: Can't add item to For Each action in flow designer

[Ken Berger]

Hi folks,

I am working on an integration with ePlus and am trying to get attachments to be posted to their SNOW instance.  I am working in Flow Designer and using the Integration Hub. I am using the OOB "Look UP Attachment" action followed by a "For Each" step to loop through the returned attachment list but I cannot add any of the outputs from my "Look Up Attachment" step.  It is not allowing me. Here is a screen grab of my flow:

Can someone provide help as to why I cannot add this?  I have tried the data pill picker as well as drag & drop but neither has worked.

Thanks,

Ken

[DrewW]

Is look up attachment designed to return more than 1 row?

[Ken Berger]

Hi DrewW,

Thanks for your reply.  Yes, one of the outputs is:

Attachment ListData type: String

Stringified JSON Object that has all the attachments returned with File name and File size properties.

Best,

Ken

[Ken Berger · Accepted solution]

I got this figured out 🙂

So, instead of using the OOB "Look UP Attachment" action, I used the "Look Up Records" action.  This allows me to setup my condition manually as "WHERE 'Table sys ID' is 'Trigger - Record Created.Incident Record.Sys ID'". The "For Each" Flow Logic then accepted the "Attachment Records" data pill of the Action Output.

Now to figure out how to POST these to the target incident 🙂

Thanks,

Ken