Agol External Hosted csv Choice List Not Working

[JoshHabel]

I have several surveys that depend on a single hosted csv choice list stored on agol. These surveys include a select one type question that uses the csv file to populate its list. This has worked just fine for several years until this week. Now the pick list for the question in survey field is blank. I have not changed anything other than updating the hosted csv file. I’ve checked rechecked and triple checked that file and the survey form.  This is very frustrating as this was working fine and now it’s not. I’ve tried creating a test survey with just a single question set up to pull from a new and separate csv and I can’t even get that to work. There is no other explanation for this other than some update Esri pushed must have created a new bug or more scary maybe they just decided to remove that option completely. Has anyone else experienced this recently???

Frustrated,

Josh

[DavidPike · Accepted solution]

I'd check the sharing on that CSV if it's somehow changed after an update.  Would also compare the newest CSV to a previous working one in notepad and see if any obvious issues/differences - check for any missing columns (name, label should pre present and comma-delimited.  No spaces or special characters in the name column) . 

Does the CSV show as linked content for each Survey in the S123Connect app or S123 website?

Does the 'type' column in the surveys look likes it's referencing correctly?
select_one_from_file 'your csv name.csv'

[JoshHabel]

I'm looking into the sharing possibility as an issue although everything appears shared correctly.

Josh

[JoshHabel]

Ok i finally got things to work again. I had to create a new hosted csv file, i named it something completely different, set it to public share, update my survey republished and now it works.  I'm going to go with sharing was the issue but  I don't understand how it can say its shared correctly but its not.  Maybe a case of some many moving parts, esri just got confused....