Howto handle umlauts in Logic App for export to csv

Paul Richardson 0
Viewed 72

I created a logic app to export some data to a *.csv file.

Data which will be exported contains german umlauts.

I read all the needed values into variables which are then concatenated and added to an array.

Finally I get an array of semicolon separated strings with the values in it.

This result will then be added to an email as file attachment:

enter image description here

All the values are handled correctly in the Logic App and are correct in the *.csv file but as soon I open the csv with Excel, the umlauts are not shown correctly anymore.

Is there a way to create explicitly a file with the correct encoding within the logic app and add the file to the email instead of the ExportString?

Or can I somehow encode the content of the ExportString-Variable?

Any hints?

export azure-logic-apps csv encoding excel
1 Answers

I have reproduced in my environment and followed below steps to get correct output in CSV file:

My input is:

enter image description here

I have sent the data into CSV table as below and then created a file in file share as below:

enter image description here

Then when i open my file share and download the content from there i got different output as you got:

enter image description here

Then I opened my Azure Storage explorer and downloaded it as below:

enter image description here

When i open in notepad the downloaded file:

enter image description here

I get the correct output, try to do in this way

And when i save it as hello.csv and keep utf-8 with bom like below: enter image description here

Then I get the correct output in csv as well:

enter image description here

RithwikBojja0
Related