cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

SFTP connector and special characters in csv file

Hi!

 

I have encountered an issue when files are copied with the SFTP connector from a sharepoint site to a SFTP server with special characters in csv files. It seems this has started suddenly from somewhere around end of March 2019. At least one special character it changes is á to ï¿½ instead.

This same flow also moves the file from one place to another after the SFTP connector on the sharepoint site and the file is ok when that is done.

 

Here is the flow:

 

2019-05-06 14_57_01-Edit your flow _ Microsoft Flow.png

 

Thanks in advance for any help!

3 REPLIES 3
Highlighted
Post Prodigy
Post Prodigy

Re: SFTP connector and special characters in csv file

Hi @markus_a,

 

Depending on what you type, it should be French, if your expected character is á, please type á instead.

 

This link is UTF-8 Encoding Debugging Chart as below:

https://www.i18nqa.com/debug/utf8-debug.html

 

If you still have problem, I advise you to do nothing but wait for this file to be cleared or to resubmit request to restart the flow.

 

I hope it can help you.

 

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
New Member

Re: SFTP connector and special characters in csv file

Hi @v-lin-msft ,

 

I can unfortunately not change what is coming out of the source system, it comes in the csv file as e.g. á or ø.

 

Why is the SFTP connector changing the character when it runs?

Highlighted
Post Prodigy
Post Prodigy

Re: SFTP connector and special characters in csv file

Hi @markus_a,

 

Perhaps utf-8 does not support the conversion of French vowels in CSV file format. You may could to try other methods, such as changing connetor in other file format to store your data.

 

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (6,008)