Views:

Applies to Product -Power Pages

What’s happening?
When downloading an extract from a Power Pages application connected to a Dataverse table, the values in one column are different from those in the Dataverse table. Specifically, the application extract contains a single quote followed by a hyphen (e.g., "'-") while the Dataverse table contains only a hyphen ("-").


Reason:
This arises due to an intentional fix implemented to protect against CSV injection attacks. This fix adds a single quote before hyphens when exporting data through FetchXML to prevent Excel from interpreting the hyphen as a formula.


Resolution:

  1. If the data cannot be controlled before export, instruct users to remove the single quotes in Excel using the Find and Replace feature:
  2. Press Ctrl + H.
  3. In the Find what field, enter '.
  4. Leave the Replace with field empty and click Replace All.
  5. Alternatively, consider modifying the FetchXML query output by using a calculated field or a Power Automate flow to replace or process the hyphen (-) before exporting. For example, replace it with a different character or format the field explicitly as text.