Power Platform Community Forum Thread Details

Converting accented characters

So, correct me if I'm wrong, but I couldn't find any way to convert accented characters other than humongous pieces of code and formulas that 90% of the time just don't work?
In MS SQL I can use TRANSLATE. But in Dataverse, everything that I find is to use Power Automate, or use substitute (which never works).

Thanks for the help.

Categories:

Microsoft Dataverse

It is annoying that Power Automate doesn't have a function to convert strings to HTML friendly text.

In Power Automate I liked to use Fetch XML queries (as opposed to OData filters) to filter Dataverse rows that might have a single quote ( ' ) in the name. It will unfortunately still break if there are certain other reserved characters (like say an ampersand or a double quote). For those I use a couple replace actions to convert them to HTML entity equivalents.

Basically a formual like this works 99% of the time:

replace(
    replace(
      replace(
        replace(triggerBody()?['text'], '&', '&amp;'),
        '<', '&lt;'
      ),
      '>', '&gt;'
    ),
    '"', '&quot;'
)

You can create your Fetch XML search by opening the table in question in a Model Driven App and clicking "Edit filters"