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

Mike McGranaghan 1 Reputation point
2022-02-15T06:54:33.3+00:00

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

174304-image.png

174305-image.png

174336-image.png

174298-image.png

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,887 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Mike McGranaghan 1 Reputation point
    2022-02-16T14:07:10.657+00:00
    0 comments No comments