I have been successfu in adding attachments to an Asana task using the API through Power Automate Flow. However, even though I can successfully add Microsoft Office documents as attachments, they seem to be corrupted and will not open. I can successfully attach other types of files, such as PDF, png, and jpg, and each one opens, but Microsoft Office files that I attach through Power Automate will not open.
I am using a “Get File Content using Path” action to get the file content. I have tried loading the content as is from the action, as well as trying ot convert it from Base64 using the Binary, Base64toBinary, and Base64toString functions. I have also tried using the File Content as application/octet-stream, as well as the modern types for Office and the legacy versions. I can’t seem to find the correct combination.
Does anyone know how to do this correctly? I have checked multiple AI chatbots, but can’t seem to find the correct solution.