Using an external choice list with a choice filter in the web form on a select multiple - list not populating

[MeganEngel]

I'm having trouble with a Survey123 web form where a "select_multiple" question uses an external choice list and a choice filter. The list isn't appearing in the web form, though it works fine in Survey123 Connect.

What I've Tried:

• XLSForm Check: All references and filter logic seem correct.
• Browser Testing: The issue persists across different browsers
• Mobile App: Works as expected
• Connect Test: The list appears without issues in Survey123 Connect.

Questions:

1. Is there a known issue with this setup in web forms?
2. Any workarounds or solutions to make the list appear correctly?

Thanks for any advice!

[abureaux]

No limitations.  There may be wrong with the CSV. Any chance you can share it here?

Here is an external select_multiple I did as a test. This CSV as ~1300 choices and it displays fine in web.

(name list, so names censored. I know this isn't a lot to go off of, but trust me when I say it's a working External Select in web!)

[JacobCabral]

Hello!

The survey and associated external lists are attached below. Any feedback would be greatly appreciated!

Thank you

[abureaux]

Still publishing.

But before it even finishes, I will say the issue is with the CSVs. Your column names are incorrect. Your first two need to be "name" and "label", just like the "choices" tab in the XLSX

[abureaux]

Went through the files. Found these couple items:

• Don't use "reserved" names. It causes a bunch of issues which can become especially prevalent once published.
  
• External Choice Lists need to have the "name" and "label" column to work properly (same idea as the "choices" tab of the XLSX).

Missing fieldinfo.csv, which I believe is the main drop-down you were having issues with. Also missing producerinfo.csv, which is used to filter fieldinfo later on (I just removed that filter). I used a copy of idnumbers_media(1).csv for now. I also cleared the relevant column just to make testing easier. The list worked as expected (obviously the wrong list due to limitations above):

I would check the format of the CSVs, and replace that reserved name within the XLSX. Give it another try after that and hopefully it works.

[JacobCabral]

Hello Abreux, 

Fantastic, thank you for the suggestions! I'm going to try these immediately.

[abureaux]

No worries! Hopefully the column names is all that's really wrong.

[JacobCabral]

Also my apologies, I changed the names of the CSVs from the originals and forgot the Survey XLSX called the wrong names. My fault on that.

[JacobCabral]

Made all the edits you suggested plus changes to the linked content and everything seems to work. Thank you again!

[abureaux]

Fantastic news!