cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
masaustin
Frequent Visitor

Convert exvel to CSV UTF-8

Hello everyone,

 

I just create a flow to convert current excel value to csv file and it works, but I need it to be output in CSV UTF-8 format, is there any way it can be done??

 

csv.PNG

4 REPLIES 4

@masaustin 

Hi there.  I found a couple of options that might work depending on your comfort level and access:

  1. It looks like we might be able to use Python to encode the csv to UTF-8, which means we can call an Azure Function to run that (maybe)...I'm not a dev, just putting together some things I've seen.
  2. I also found a similar solution using PowerShell - 
    Get-Content .\test.txt | Set-Content -Encoding utf8 test-utf8.txt
  3. Since you can do the conversion in Excel, also, this might be a good opportunity for a UI Flow.  You'd need it to run on a local machine, but it's a solution.

Let us know what you think of those.  Maybe there are some other ideas floating around.

 

-Ed

 

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

chanwulee
Advocate I
Advocate I

If your .csv file shows broken characters instead of Chinese, it is because the encoded file does not include BOM for UTF-8. So, please add 3 BOM characters as below. It will show the text normally in excel.
 
concat(uriComponentToString('%EF%BB%BF'),body('Create_CSV_table'))

Thanks for your reply, but after I add the 3 BOM characters, it still can't output correctly, seems nothing change in the contents.

 

masaustin_0-1634544201617.png

 

fawadSid
New Member

@masaustin  any update on this?

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (3,538)