When genrerating csv in Flow, you may find some characters are garbled, e.g. Chinese, as bleow.
This is due to inappropriate Unicode charset set to CSV file.
To fix this issue, we need change it to utf-8, which basiclly supports all characters!!
Since csv is also a kind of text, we can use Byte order mark(BOM) at the start of csv to tell the software that “Hey, I’m encoded as utf-8! Don’t make me grabled any more!”
The UTF-8 representation of the BOM is the (hexadecimal) byte sequence
https://en.wikipedia.org/wiki/Byte_order_markEF BB BF
So the solution is simple, we just add BOM characters(EF BB BF) in fornt of csv content.
concat(uriComponentToString('%EF%BB%BF'),body('Create_CSV_table'))