February 25th Survey123 update broke external choice list in the survey

[YuliaMamonova]

Hi,

This is what I see in the update for Survey 123 field app:

• External select choice filters can now use name values as numbers.

The reality:

I had external choice list for the survey (Nan string value and numbers):

Worked fine like this, and still works in Connect (I have not updated it):

This is what is happening in the field app (instead of Nan I have selection mark):

Thanks,

Yulia

[YuliaMamonova]

Update: I have updated connect and now external choice list shows the same behavior as the field app. Tried recreating the csv, but still only numeric-like values are showing up in the dropdown. Please suggest!

[YuliaMamonova · Accepted solution]

Update: Changed "Nan" to "Not Found" and it now displays in the dropdown. Has "Nan" become a reserved word or something?

[DanPatterson]

nan = > n(ot) a n(umber)

NaN - Wikipedia

[YuliaMamonova · Accepted solution]

Yes, but it worked fine previously so it confused me. The data is coming from a third party and is pulled into csv, so I asked them to change it from Nan to smth else, and now it's all good. Thank you.

[JamesTedrick · Accepted solution]

Hi Yulia,

As described in the 3.12 What's New blog post, the list processing has changed to be more robust and performant.  If you wanted a value nan in a sequence of numbers, you would need to ensure that is in double quotes in the CSV file