web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Converting accented ch...

Power Apps

Suggested Answer

Converting accented characters

(0) Share

Report

Report

Posted on by CU20121206-0

2

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 with Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Mark Nanneman 993 Moderator on at

Like (0)

Report
Copy link

Link copied!
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'], '&', '&'), '<', '<' ), '>', '>' ), '"', '"' )

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

Then write something like this (I put a placeholder in {{ just so it's easier to find in the final XML).

Click "Download FetchXML and open it in a notepad, then copy and paste it in your flow.

Replace the placeholder variable with a dynamic reference. Here I just drop in a compose action that does the replace functions for ampersands etc.

Example, searching for A&W

Hope that helps!

Was this reply helpful? Yes No
Suggested answer

CU20121206-0 2 on at

Like (0)

Report
Copy link

Link copied!

@Mark Nanneman

I ended up finding this little solution here:
Solved: Re: Convert names to email address - Power Platform Community

But thanks for the tips, man.

Was this reply helpful? Yes No

Join the conversation