Help with dropdown list from a CSV file

Question

I am currently creating a form that must be filtered based on the user's login, it does not filter the list and additionally shows me the repeated options and with errors in the representation of the list, that is, the accents are shown with a ? sign.

I have previously worked without problems but lately I have not been able to correct this issue, could you please help me. I am sharing with you what I have so far.

teste.xlsx

proyectos.csv

Real-Time at FedGIS 2025.png

JoseBarrios1 · Answer

Saludos YenniferCedeño

The reason that your accents ( and other characters) are shown with a ? sign is because you need to save your .csv file to UTF-8 encoding (see pic below). Also your "search" expression is wrong. It should be: autocomplete search('proyectos','matches','usuario', ${nombre_usuario}).

dougbrowning · Answer

This means you have special chars in there.  These in particular are very common if you copy paste from a PDF.  Always use paste values and not just ctrl-v.  Always.

One way to fix without starting over is to open the CSV in Notepad.  Then you can see the special chars and remove them.  Using excel hides all this on you.

Other way is start over and use paste values instead.  This often works but not always.