"Create file" action in Logic Apps cannot show special characters

Question

To summarize shortly. I need to transform a big xml file into a .csv file while also chosing specific fields of data.

1. I get a big xml file
2. I convert it to Json using a Compose action
3. I compose the fields I want from the json in a "Foreach"loop
4. I append it to an array variable (Within the foreach loop)
5. I use the "Create CSV table" action
6. I use the "Create file" action from the "Azure file storage" and it successfully creates a .csv file that has the data I want.

These are my problems:

1.

So I can see that the data going into the "Create file" action can successfully show the letter " Ö ". However, this is how it looks when the final file is shown. "Göteborg"

I cannot figure out how to make sure that the special letters will be shown. I've tried things like "base64ToSTring" but it's not accepted since the data is an array.

2. The second issue I have is that my compose action is ordered alphabetically. So the final result I get in my file shows "City" infront of "FirstName" for example. I want "FirstName" to show first but after a lot of testing I cannot get it to order in the way I want.

---

Helpful for any tips on how to create this .csv file properly and in the way I want.

Answer 1

The design in Logic apps is right (the problem is in local the way it is storing):

Output as been stored as it is :

But when downloaded it shows this way(problem with local not azure):

Helpful for any tips on how to create this .csv file properly and in the way I want.

So, the alternative way is created a normal file and then save it as UTF-8 with BOM and then save it as name.csv. Refer this SO-Thread for the same:

Then Download the file and then save it as:

then it will show the required format: