Logic App - Create a CSV table from a JSON file with a BOM marker

Question

I'm trying to create a CSV table which has emoji's in it and send it as an attachment via logic app. So far, my app creates the JSON with the emoji's in it fine, and it looks as though the input going into the Create CSV Table action is also fine. But when I download the CSV created from my email, the emoji's are in gibberish and I realise that is because the CSV has been created without a BOM marker.

Any ideas how I can fix this? I've already tried the below solution but I don't think it works because of the conversion from CSV into bytes required to attach a file to an email.

https://techcommunity.microsoft.com/t5/integrations-on-azure-blog/create-csv-files-with-bom-marker-in-logic-app/ba-p/2919113

Answer 1

Someone answered my question here: https://stackoverflow.com/questions/71122384/create-a-csv-table-from-a-json-file-with-a-bom-marker-in-a-logic-app