web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details
Power Automate - General Discussion
Answered

Accent errors - CSV files - UTF - 8

Like (0) ShareShare
ReportReport
Posted on 21 Mar 2022 19:42:14 by 55

Hello, 

 

I am having a hard time copying a CSV file from email to one drive. The file contains words with accents. For example: "Québec". If I just use a 'base64tostring' function I get the result "Qu�bec". 

 

I tried to convert to UTF -8 format by using the expression 

"concat(uriComponentToString('%EF%BB%BF'),base64ToString(items('Apply_to_each')?['contentBytes']))". After that I got the word "Qu�bec". 
 
Can anybody help me with that?
 
Thanks
 
Paulo
I have the same question (0)
  • Verified answer
    pmota Profile Picture
    55 on 31 Mar 2022 at 20:01:51
    Re: Accent errors - CSV files - UTF - 8

    Hi @Expiscornovus ,

     

    I think I finally got the solution. I used the "base64tobinary" function without the 'BOM' expression. 

     

    pmota_0-1648756778345.png

     

    Again, thanks and have a great day! 

     

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 788 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 452 Moderator

#3
developerAJ Profile Picture

developerAJ 302

Last 30 days Overall leaderboard
Loading complete
Loading complete