Unanswered

Flow Corrupts CSV File - Copy from FTP to OneDrive

(0) Share

Report

Posted on by gustavofill

Hey guys!

I'm trying to pull some files from the FTP server to OneDrive(Personal) as soon as they are added/modified, however, when I pull them, they get corrupted.

However, if I get it directly through another program, the file comes out perfect.

I have already marked the parameter "Binary Transport".

I don't know what else to do, can you help me please?

Grateful.

csv error.png

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

elliottliu 13 on at

Like (0)

Report
Copy link

Link copied!
Hello!

I just spent some time figuring out what was going on here. It seems like it's to do with the way Power Automate encodes the .csv file when it's created. You need to get the .csv file encoded into a UTF-8 format. To do this, you need to add some special characters at the beginning of the .csv file:

concat(uriComponentToString('%EF%BB%BF'), body('Create_CSV_table'))

In your instance, replace the "body('Create_CSV_Table')" with the file coming from your FTP server.

I've tested it out and can confirm that this works.
Power Automate CSV UTF-8 Encoding
I found this workaround via @Expiscornovus replying another user with a similar issue (Try to create CSV file but it unable to read Thai language).
They discovered this via @chanwulee who originally solved the issue (Create a .csv file that uses UTF-8 character encoding).
An article walks you through how to import UTF-8 encoded file into Excel (How to import a .csv file that uses UTF-8 character encoding).
Hope this helps!

Was this reply helpful? Yes No
gustavofill 4 on at

Like (0)

Report
Copy link

Link copied!

Hello elliottliu!
First of all, thanks for taking the time to help me!
I made the attempt as mentioned by you, the flow worked, however, the final file is still corrupted, as shown in the screenshots below.

Was this reply helpful? Yes No
elliottliu 13 on at

Like (0)

Report
Copy link

Link copied!
Hi, no problem!

Sorry for the confusion, the screenshot I included above is just for demonstration purposes. You should only need the two steps as you did in your original flow.

In the the OneDrive for Business "Create file" action try replace the "File Content" with the expression:
concat(uriComponentToString('%EF%BB%BF'), triggerOutputs()?['body'])
You may need to substitute "triggerOutputs()?['body']" with the dynamic content output from your FTP trigger action.

It should look something like this when you're done.

Was this reply helpful? Yes No
gustavofill 4 on at

Like (0)

Report
Copy link

Link copied!

Hi!
Unfortunately the problem remains, I think this decryption method is not working.
When I open it in notepad, it shows me "UTF-16 LE" as print. I don't know if that helps.

Was this reply helpful? Yes No
mattiabergo 17 on at

Like (0)

Report
Copy link

Link copied!

Hi,
I've the same issue by using an xlsx instead. comes from his source correct, but after the FTP get content action it is corrupted, even with the binary transfer flag set.

This is my topic link: FTP downloaded Excel file is corrupted - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No