Skip to main content

Notifications

Community site session details

Community site session details

Session Id : BvzAnqD7GkWi2oZ2a3p4Lr
Power Apps - Building Power Apps
Unanswered

Return search results with and without accents

Like (2) ShareShare
ReportReport
Posted on 27 Jun 2019 08:49:03 by 512

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. 

Categories:
  • HFG Profile Picture
    512 on 17 Nov 2021 at 13:10:24
    Re: Return search results with and without accents

    Hi @MadAusi 

     

    You would put the formula where the text is that you're using to search, it wraps around your search text. So something like this:

    Search(
          Table/CollectionName
               ,Subsitute Formula with Search Text
    ,Table/Collection Column to search in 
    )

    Hope that helps

  • MadAusi Profile Picture
    2 on 02 Nov 2021 at 13:33:44
    Re: Return search results with and without accents

    Hello,

    thanks a lot for this solution wich seems to work.

    But can you help me, cause i dont know where to put exactly this formula .

    Waiting for an Help

    Thanks

    MadAusi

  • NicolasLima Profile Picture
    14 on 03 Aug 2021 at 13:33:46
    Re: Return search results with and without accents

    Thanks YoelG, this workaround helped me a lot. I work in Brazilian Portuguese, so here is my pt-BR version.

     

    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(Substitute(Substitute(TextInput.Text;"À";"A");"Â";"A");"Á";"A");"Ç";"C");"È";"E");"É";"E");"Ê";"E");"É";"E");"Î";"I");"Í";"I");"Ô";"O");"Ó";"O");"Ù";"U");"Û";"U");"Ú";"U");"à";"a");"â";"a");"á";"a");"ã";"a");"ç";"c");"è";"e");"é";"e");"ê";"e");"é";"e");"î";"i");"í";"i");"ô";"o");"ó";"o");"õ";"o");"ù";"u");"û";"u");"ú";"u")
  • GeekAlf_Pro Profile Picture
    400 on 03 Mar 2021 at 15:23:54
    Re: Return search results with and without accents

    Chapeau bas !

     

    Serviteur Monsieur

  • HFG Profile Picture
    512 on 03 Mar 2020 at 11:18:52
    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. 

  • YoelG Profile Picture
    24 on 02 Mar 2020 at 14:28:23
    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 !

  • YoelG Profile Picture
    24 on 02 Mar 2020 at 10:54:29
    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

  • Glitch_IT Profile Picture
    17 on 12 Sep 2019 at 00:15:52
    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

  • v-yuxima-msft Profile Picture
    on 04 Jul 2019 at 09:26:55
    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

  • HFG Profile Picture
    512 on 28 Jun 2019 at 11:27:08
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
MS.Ragavendar Profile Picture

MS.Ragavendar 20

#2
BCBuizer Profile Picture

BCBuizer 10 Super User 2025 Season 1

#2
LC-26081402-0 Profile Picture

LC-26081402-0 10

Overall leaderboard
Loading started