To summarize shortly. I need to transform a big xml file into a .csv file while also chosing specific fields of data.
These are my problems:
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.
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: