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.
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?
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.
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
Keep your eyes open for our upcoming T-shirt design contest!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020