Published Form is not pulling data from csv.

[KeshavSingh1]

I am building a form in Survey123 Connect where users enter their employee ID, and the form pulls their name from a CSV file. The lookup works correctly in the Survey123 Connect app, but it doesn't work in the published form.

I have checked that the CSV file is located in the media folder. I have also tried re-uploading the file and even creating a new CSV file. 

Is there anything that I am missing?

[Neal_t_k · Accepted solution]

Connect can be less stringent on rules than the field app or web app. Check that your CSV column headings are all lowercase and check for special characters in the lists. Also ensure that the call to your list in the xlsx matches the case of the CSV file name. If that doesn't work it would help if you could show some example screenshots or upload the xlsx and csv for troubleshooting.

[KeshavSingh1]

Thanks @Neal_t_k for the response, my columns were uppercase I made them lowercase and it worked.