cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ccammack
Regular Visitor

Can't convert SharePoint Attachments to Base64ToBinary

Hi,

I've been stuck on this flow for a little while now...  The error states: The execution of template action 'Attachment_to_Ticket' failed: the result of the evaluation of 'foreach' expression '@outputs('Get_attachment_content')?['body']' is of type 'Object'. The result must be a valid array.

This flow is supposed to take a SharePoint item attachment and upload it via HTTP connector.  The ideal result would be similar to what is shown in the Attaching a file in Zendesk section here: https://4sysops.com/archives/using-the-zendesk-api-with-microsoft-power-automate/

I would appreciate any help! Thank you!

ccammack_1-1629229117581.png

 

 

1 REPLY 1
tom_riha
Super User
Super User

Hello @ccammack ,

the error message tells you that the input of 'Attachment to ticket' loop is an object, not an array. You're using the attachment content, that's not something you can loop through. Move the actions inside 'Attachments to ticket' directly in the 'Apply to each 2' and then remove 'Attachment to ticket'.



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,445)