Hi @Anonymous ,
The cause of this problem is:
.csv file is a kind of text file. If you encode it in UTF-8 format, there are two ways to save it.
- Text only
- Byte Order Mark(BOM)+Text
BOM is 3 characters (EF BB BF) to mark the file is encoded as UTF-8.
When you generate .csv file in Power Automate, it does not include BOM.
So, when you open the .csv file in excel, special characters(i.e. Korean) will be broken.
The solution is to add 3 BOM characters in front of the .csv file content before saving it.
concat(uriComponentToString('%EF%BB%BF'),body('Create_CSV_table'))
Here is a test for your reference:
Here is result:
