Pulldata from a media .csv not working

[RemyOlive]

Hi everyone,

I'm fairly new to Survey123 connect, and have been trying to collect latitude and longitude data from a CSV file located in the media folder of my survey.

I'm doing this through a pulldata() function, as shown here:

 Survey123 Tricks of the Trade: How to calculate a geopoint (esri.com): 

RemyOlive_0-1725266670462.png this is my pulldata query.

RemyOlive_2-1725266981841.png

and this is my CSV table located in the media folder.

Whenever I select one of the list's choices, neither of the two pulldata() fields fill with the lat and long.

I think I've tried everything that I could find on the forums, from notepad checking my csv to removing any potentially special characters as seen here:

Solved: Pulldata From Linked csv Not Working - Esri Community

Solved: pulldata function not working in survey - Esri Community

Solved: Pulldata from external csv not working - Esri Community

Still not working for me, any help would be appreciated ! 

Thanks,

Rémy

[Ruth_JiatengXu]

Hi @RemyOlive ,

Could you please also provide a screenshot of your choices tab in the XLSForm? I think we also need to check the choice list "WP" for the "select_one WP".

Thanks,

Ruth

[RemyOlive]

Hi Ruth,

Thanks for the reply,

RemyOlive_0-1725275065682.png

here is the screenshot of the WP choice list, pretty basic stuff as all other columns are empty, I made sure that these are the same as the IDs from the media table.

Thanks,

Rémy

[Ruth_JiatengXu]

Hi @RemyOlive 

I created a survey based on your screenshot, and it worked for me. The XLSForm and csv file are attached to this post.

Ruth_JiatengXu_1-1725359505722.png

Could you please try my form in your Connect or share your XLSForm with us?

Thanks,

Ruth

[abureaux]

Your CSV is wrong.

abureaux_0-1725381075987.png

The "name" and "label" columns are required, just like on the Choices tab.

EDIT: For clarity, the screen shot above is from OP. Here is an example of what it should look like (note the addition of the "name" and "label" columns):

abureaux_1-1725461904967.png