Dynamic Choice filter With Select multiple

Question

I am trying to apply a choice filter to a select one from csv question. The choice filter is base on selections made in  to a previous question, ${Region}. The ${Region} question is a select multiple and has four choices Peninsula, South, Panhandle and North. The csv with the choices has four four fields Peninsula, South, Panhandle and North in addition to name and label. The region fields in the csv are Binary (0, 1).

I have tried both functions in the XLS Form and JavaScript functions. In both cases the, when a region is selected the choice list is null.

Any ideas? Thanks.

Survey123 Connect 3.22.49

Template version: 3.22

species_list.csv

Plant_Regions.xlsx

CurtisMusson · Answer

Solution: 
selected(${region}, Panhandle) or selected(${region}, North) or selected(${region}, Peninsula) or selected(${region}, South)

CurtisMusson · Answer

Shoot, I attached the wrong csv to the original post.  The content in the csv files is exactly the same. The only difference is the file name.

Maybe the guidance will help.

plant.csv

Lei_Liu · Answer

Hi CurtisMusson,

Thank you for providing the XLSForm. I noticed that your form references a choice list from a file named plant.csv, but the CSV file you've attached is species_list.csv. To ensure the choice list populates correctly, please verify that plant.csv is included in your media folder.

For additional guidance, you might find Esri's sample Choice Filters and Cascading Selects helpful: https://www.arcgis.com/home/item.html?id=9a7af83953584aedb6f60d9cd6747ffc