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??
Hi there. I found a couple of options that might work depending on your comfort level and access:
Get-Content .\test.txt | Set-Content -Encoding utf8 test-utf8.txt
Let us know what you think of those. Maybe there are some other ideas floating around.
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.
Thanks for your reply, but after I add the 3 BOM characters, it still can't output correctly, seems nothing change in the contents.