Create file without Byte-order marker

(0) Share

Report

Posted on by TomBrabo

Hello everyone

I encountered a problem with the Byte-Order Marker (BOM). For an application, I'm creating/updating a JSON file which is present on a website and will be used to show data.

In Power Automate I'm creating the JSON file based on data selected from a sharepoint list. This is working as it should be but when the file is exported as JSON, Power Automate adds a BOM. When using it on a wordpress website, the table plugin will not recognise the JSON file as containing any data because of the presence of that BOM (I can see it as a red dot).

When i manually delete the red dot (BOM) using Notepad++ of a build in editor everything is working fine.

Because of the automated process it isn't an option to delete the BOM everytime the JSON file is updated. Is there a way to ensure that the BOM isn't added when the file is created in Power Automate?

Thanks for the reactions.