Choice Filter/Cascading Select Not Fully Functioning

[AndrewSouthern]

I have something strange going on.  I have a choice filter set up and only a partial amount of the external choices are coming through.  The external choice sheet is large, over 46,000 rows, but I'm not convinced that's the issue.  Specifically what I'm seeing is that only some external choices are coming through but not others.  Some "groupings" of answers are not coming through at all, others come through as expected.  A real mixed bag so it has been difficult to pinpoint the issue.

I have attached a couple screen shots as well as the XLS form if anyone wants to try to help me navigate this issue.

Thanks.

[AndrewSouthern]

I believe I figured it out.  There were commas in some choices and the CSV created (itemsets) does not jive well with Survey123 if there are commas involved.

[DougBrowning]

I was just going to write that it may be commas.  Happened to me.  Note it seems to be commas anywhere in external choices - even columns you do not use.

Also had issues if there are any " or ' in there. 

You get really weird lists and data stored so it can be hard to figure out.

[AndrewSouthern]

Thanks that's good to know as well.