CSV file encoding

(0) Share

Report

Posted on by J-vdB

Hi guys!

I'm having an issue with CSV files that I move with SFTP to a Sharepoint folder. The orignal files are encoded as ANSI. When I open the CSV files after they are moved to Sharepoint, some special characters are corrupted (for example: é becomes �). The new files are encoded as UTF-8.

I tried the solution suggested here. That changed the encoding to UTF-8 with BOM but still I see the corrupted characters.

This is the flow I have:

I'm using the 'SFTP - SSH' trigger 'When a file is added or modified' and the Sharepoint action 'Create file'.

When I debug the flow it seems the characters already get corrupted at the first step in the trigger. When I download the raw output with 'Click to download', the characters are already corrupted.