Survey isn't pulling in list from media .csv

[NicoleCarter]

Working on a survey trying to allow a user to select from a list of plants, pulling from a .csv in the media file (line 46 in the form .xlsx). For the life of me I can't figure out why it isn't working. Probably something obvious. 

[RoryMcPherson]

In your form it looks like you've forgotten to reference the csv file after select_one_from_file. If you add the file name after this it should work - e.g. select_one_from_file filename.csv

[NicoleCarter]

Well that's what I thought too, but it still isn't working...

[ValerieCaden-Baptiste · Accepted solution]

Hi Nicole, I noticed there were some extra lines in some of the items in the CSV file:

I removed the extra lines and was able to successfully pull data from the CSV file. I also saved it as the CSV UTF-8 format, removed all columns except for label/name for testing, and changed the appearance to minimal, and then back to autocomplete for testing. Please let me know if this helps!

Resource: https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-external-choice/ba... 

[NicoleCarter]

That worked! Thank you! Unfortunately I do need to access the other columns so I will scrub them and add them back one by one. Thank you again!