cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HFG
Level: Powered On

Return search results with and without accents

Hi, 

 

I am working on a App in French so there are various characters with accents (éèàû..). I have a search box set up to filter a gallery. I would like the search results to return words with accents even if the person types it in the search box without, e.g. if they search "Petrochimie" and the name in the gallery is "Pétrochimie" the result is still returned, is this possible? 

 

Thanks in advance for your help. 

7 REPLIES 7
Community Support Team
Community Support Team

Re: Return search results with and without accents

Hi @HFG 

 

What is your formula expression of your gallery currently?

You can use Searchbox.Text in Column Name to achieve that, if you put the words which in the Column Name, it will show.

Could you please reference this:

function-filter-lookup#search-user-experience

search.gif

 

 

Best Regards.

Yumia

 

HFG
Level: Powered On

Re: Return search results with and without accents

Hi @v-yuxima-msft

 

My formula is as follows: Search(colProj,TxtNomProj_SaisieProj.Text,"TXT_Libelle").

 

The search is working, but I would like to know if when I type a word without an accent whether in the results I can also have items with accents? Eg. Item in gallery is "Pétrochimie" if I search "Petrochimie" is there a way I can I have this item show up or can only exact matches be returned? 

 

Thanks

Highlighted
Community Support Team
Community Support Team

Re: Return search results with and without accents

Hi @HFG 

 

You can also use the formula expression as this

Filter(datasource, Textinput.Text in ColumnName)

If you input the letter in the words "Petrochimie", for example if you input "imie", all the words which contains these letters will be display.

 

More information:

function-filter-lookup

 

Best Regards.

Yumia

Glitch_IT
Level: Powered On

Re: Return search results with and without accents

Hi Yumia,

I think you didn't get what the question is here.

I would be very interrested in a solution to this problem too.

In essence, this is what we are looking to achieve:

Search for: resume

Returned results: résumé, resume, etc

YoelG
Level: Powered On

Re: Return search results with and without accents

Hi,

 

Still no news on this point ?

I'm trying to find a workaround for several days now, but for now I only found a headache...

Any experts to find us a trick ? Please

 

Many thanks

YoelG
Level: Powered On

Re: Return search results with and without accents

@HFG 

 

I finally found a workaround ! 🙂

 

I created a formula to Substitute all the accented letters.

Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(YOURLABEL.Text;"À";"A");"Â";"A");"Ä";"A");"Ç";"C");"È";"E");"É";"E");"Ê";"E");"Ë";"E");"Î";"I");"Ï";"I");"Ô";"O");"Ö";"O");"Ù";"U");"Û";"U");"Ü";"U");"à";"a");"â";"a");"ä";"a");"ç";"c");"è";"e");"é";"e");"ê";"e");"ë";"e");"î";"i");"ï";"i");"ô";"o");"ö";"o");"ù";"u");"û";"u");"ü";"u")

 

In my case, I just needed these letters, as I'm working in French, but, I found a list with all the existing accents, so you can edit the formula according to it if necessary :

nonaccentarray = Array("A", "A", "A", "A", "A", "A", "C", "E", "E", "E", "E", "I", "I", "I", "I", "I", "N", "O", "O", "O", "O", "O", "U", "U", "U", "U", "Y", "a", "a", "a", "a", "a", "a", "c", "e", "e", "e", "e", "I", "I", "I", "I", "o", "n", "o", "o", "o", "o", "o", "o", "u", "u", "u", "u", "y", "y")
accentarray = Array("À", "Á", "Â", "Ã", "Ä", "Å", "Ç", "È", "É", "Ê", "Ë", "Ì", "Í", "Î", "Ï", "Ï", "Ñ", "Ò", "Ó", "Ô", "Õ", "Ö", "Ù", "Ú", "Û", "Ü", "Ý", "à", "á", "â", "ã", "ä", "å", "ç", "è", "é", "ê", "ë", "ì", "í", "î", "ï", "ð", "ñ", "ò", "ó", "ó", "ô", "õ", "ö", "ù", "ú", "û", "ü", "ý", "ÿ")

 

I guess that it's a "hard" workaround, but it works like a charm by my side (and it's fast !). So it should be fine until someone finds something better.

 

Hope it will help you !

HFG
Level: Powered On

Re: Return search results with and without accents

Wow, what a formula! Thanks for doing all the hard work! I'm also working in French so that will be really useful. 

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,176)