I would like to create a CSV file from MS Flow by using ANSI/ASCII encoding like we can do in PowerShell. Currently, the default output encoding is UTF-8.
In reallity, I create a flat text file for banking transactions. So, encoding is very important.
Same here. I need to create a file with windows 1252 encoding but I don't see any option to do this. 😕
We have the same issue were we want to handle some CSV files with latin ANSI encoding with special carachters and the fiel ingestion flow is messing it up.
It appears there is no way to use Power Automate to write the contents of a SharePoint list to a CSV file as that content is entered in the list. That seems incredible and I'm hoping I missed something here. Common characters such as vowel inflections in names do not survive the flow. For example, "é" is write as "Ã©" despite showing correctly in the output of "Create CSV Table" as well as the input of both "Create File" and "Update File".
The only way to work with these common characters is to use voluminous string replace routines on the assumption that ending up with the incorrect word in the output is acceptable.
This is intolerable and must be corrected. If there is a way around this please let me know, otherwise please someone, prioritize fixing this error.