cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
markus_a
Level: Powered On

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
v-lin-msft
Level 10

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.

markus_a
Level: Powered On

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?

v-lin-msft
Level 10

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

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 225 members 4,238 guests
Please welcome our newest community members: