SFTP file from email attachment

Like (0) Share

Report

Posted on 11 Dec 2023 14:40:06 by adraper

I am trying to create a workflow that copies an email attachment (CSV) to a remote server using SFTP. It appears to work, but when I download the file it appears as a random assortment of characters. I have a separate workflow that did the exact same thing that was working, but now appears to be doing the same thing. Here is the workflow:

I have tried "Get all file metadata" set to both Yes and No, with the same results.

It is a very simple workflow. The file content I am sending over looks like this:

However when it gets to the server it looks like this:

I am assuming that it converts the content to bytes but does not convert it back to text. I am confused that the other workflow was not modified but when I did a test run it yielded the exact same results. I am concerned that both are not working properly. Is there anything I am missing?

All responses (3)

Answers (1)

ericmabkv 12 on 25 Jun 2024 at 16:52:01

Like (0)

Report

Re: SFTP file from email attachment

Hello,

I am having this same issue and would appreciate if you could provide a bit more detail as to how to use the expression base64ToBinary. I am new to Power Automate and cannot figure out how to use the base64ToBinary expression. Thank you!
adraper 2 on 11 Dec 2023 at 16:22:18

Like (0)

Report

Re: SFTP file from email attachment

That worked great, thanks!
Verified answer

Paulie78 8,407 Super User 2025 Season 1 on 11 Dec 2023 at 15:22:56

Like (0)

Report

Re: SFTP file from email attachment

You need to use the expression base64ToBinary on the attachment content:

Base64toBinary