Problems with latin characters in CSV file generated with Power Automate

(0) Share

Report

Posted on by groyet

CSV file generated with Power Automate could not generate latin characters like: 'ñ' 'í' 'ó' 'á',...

I couldn't figure out how to solve this problem.

Any 💡💡💡ideas without using external sources?

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @groyet,

I assume you are using a Create file action as well, directly after the Create CSV table?

If so, you could include the Byte Order Mark characters to that Create File action. A great solution by @chanwulee, https://powerusers.microsoft.com/t5/Building-Flows/Create-a-csv-file-that-uses-UTF-8-character-encoding/m-p/1311587/highlight/true#M148980

concat(uriComponentToString('%EF%BB%BF'),body('Create_CSV_table'))

Was this reply helpful? Yes No
groyet 53 on at

Like (0)

Report

Hi @Expiscornovus ,
I send a collection from powerapps -JSON(myCollection;"GI")- to powerautomate
Then, I create a CSV table: json(triggerBody()['text'])

Finally, I create the file in OneDrive.
I have tried your expression in the file content, unfortunately did not work.
I have also tried the @chanwulee solution, unfortunately did not work.

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report

Hi @groyet,

Thanks for sharing your setup. I will have a look if I can reproduce this via a PowerApps collection and see if I can find a different fix.

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report
Hi @groyet,

I have tested a couple of things. Looks like you could use a parse json in your flow. After that you should be able to add the byte order mark characters as well. In my test I also applied a JSON Format in the Run formula within PowerApps btw.

PowerAppsLatincharacterstest.Run(JSON(myCollection, JSONFormat.IndentFour))

Ignore the Test1, Test2, Test3. I had a couple of additional parameters in my setup 😂

2. In the flow use the string input from PowerApps and a schema which should recognize it as an array. After that you should be able to consume it in the CSV table and file (with byte order mark characters added).

Was this reply helpful? Yes No
groyet 53 on at

Like (0)

Report

Thanks @Expiscornovus for your time analysing and testing this case.

I have created the flow as suggested, but I do not have knowledge to deal with 'Schemas', so my flow failed in this step. For sure there is something wrong with the schema I have provided to Power Automate.

I want to mention that I am using Powerapps v2 and sending the collection as you suggested with the JSONFormat.IndentFour.

I would like to share the input of the collection, as an example of data sent from Powerapps:
[
{
"Quantity": 500,
"String1": "Some txt with á, ó",
"String2": "Compañía",
"Date1": "02-jun-22",
"Date2": null,
"Date3": "24-mar-22",
"Date4": "02-jun-22",
"ID": 11944,
"String3": null,
"String4": "Y",
"Producción": "009989167/100",
"String6": "My SKU No",
"String7": "K"
}
]

As you can see:
-There are latin characters in some headers and in some values.
-Some values could be null.

Regards.

Was this reply helpful? Yes No