Answered

Help please, Resulting CSV file not displaying accented letters correctly.

(1) Share

Report

Posted on by ChrisChong

Good day all, a PAutomate Flow I build produces the .csv file but the accented characters are not correct. The image below should display Montréal and Côte-des-Neiges.

Please, any suggestions?

--bad--

--good--

Here is my Flow:

I thank you for your kind help.

Chris

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (2)

Sort by

Rhiassuring 8,692 Moderator on at

Like (0)

Report
Copy link

Link copied!

Bonjour, Salut!

There are some different ways to resolve this. Have you checked out this thread:

https://powerusers.microsoft.com/t5/Building-Flows/Create-a-csv-file-that-uses-UTF-8-character-encoding/td-p/559864

The item marked as the solution seemed to help others with the same problem, so, worth a shot!

Was this reply helpful? Yes No
ChrisChong on at

Like (0)

Report
Copy link

Link copied!

Thank you for your quick response. Perhaps I misunderstand how to implement the solution you suggest? No joys yet.
Chris

Was this reply helpful? Yes No
Verified answer

Rhiassuring 8,692 Moderator on at

Like (1)

Report
Copy link

Link copied!

I believe it would go in front of your File Content - so try this:

Click in "File Content".

Clear out what you have there now.

Click on the "Expression" tab.

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

Save!

Was this reply helpful? Yes No
ChrisChong on at

Like (1)

Report
Copy link

Link copied!

My apologies. It appears that the solution escapes me.
Your obtuse pupil,
Chris

Was this reply helpful? Yes No
Verified answer

ChrisChong on at

Like (0)

Report
Copy link

Link copied!

Do forgive please. Succès, ça marche bien !
merci beaucoup, Vous êtes un génie
Chris

Was this reply helpful? Yes No
Gayathri_26 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Even after adding the same line, am not getting my characters displayed properly.
"concat(uriComponentToString('%EF%BB%BF'),body('Create_CSV_Renewed'))"

Can you please tell what am missing?

Was this reply helpful? Yes No
C4thY 3 on at

Like (0)

Report
Copy link

Link copied!

Hello from Montréal 🙂

Was this reply helpful? Yes No