Unanswered

Problem with special characters csv file

(0) Share

Report

Posted on by Steven1979

CSV creation works fine, but when I open the csv file in Excel all letter with accent are converted to special characters.

All letter with accent are replaced with special characters

Can you help me please? or do you have an easiest way to create a new XLSX file instead of CSV file? Maybe would be more compatible? I dont need csv file but I didn't find an easy way to create a excel file from a sharepoint list.

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

v-chengfen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Steven1979 ,
Please try:
concat(uriComponentToString('%EF%BB%BF'),body('Create_CSV_table'))

Here is a link for your reference:
Solved: Re: Garbled text in CSV file - Power Platform Community (microsoft.com)

Best Regards
Cheng Feng

1 people found this reply helpful.

Was this reply helpful? Yes No
Steven1979 19 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the answer. I already found that solution, but that didn't works for me. Check what's happen when I open the excel file after I replace the File content = "Output" for "concat(uriComponentToString('%EF%BB%BF'),body('Create_CSV_table'))"

It's like if it dont care about the output when I put this command?!?!"?

Thanks!

Was this reply helpful? Yes No
v-chengfen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Steven1979 ,
Please fill in the formula in Expression

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Steven1979 19 on at

Like (0)

Report
Copy link

Link copied!

oups ... thanks for the specification! sorry to be so newbie for that one! 🙂

I tried, but I'm still having problems with special characters in my csv file :

Is there something else to adjust?

Was this reply helpful? Yes No
corily1810 2 on at

Like (0)

Report
Copy link

Link copied!

This post saved my day. Thnks

Was this reply helpful? Yes No