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
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

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 Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,050)