How to create a lookup using pull data functionality

Hi @york_rff
I noticed that your issue was actually with your csv file. The data in it was not being read as two columns because you had incorporated a semi-colon as a seperator.

My approach is to first create the CSV file in excel with each data in its column and then save it as a CSV file. Normally you can notice a wrong placement when you open the CSV file in excel and data fails to sit within its columns (as what you had in the previous image)

See the list I used odktestschoollist.csv (342 Bytes)

Please note that your pull data question is a calculate question but you can actually use a text question in it as I did in my form

Running this the behaviour looks as follows

Wishing you all the best in finalizing your form.