dynamic choices in a select_one question depending on previous question in csv

[ALBJORGUI]

Hi everyone, 

I want the options that appear in a select_one question to be dynamic depending on the answer given in a previous question.

Let's say I have a select_one country where the user selects country and I give the option for UK, US, Australia. This select one comes as linked content as a .csv file 

So the next question would be select_one colour and here it is where the dynamic selection would come:

If the user selects UK I want them to have red,blue, yellow as select one.

If the user selects US I want to dynamically change to red,yellow,purple, and black

and If the user selects Australia I want the options to be blue, black,white.

So my question is, can this be done? how do I create this in the choices tab in my xls?

Is it even possible? I can't cascade it as the countries come from a csv and not from a choice list of countries. 

Thanks,

Albert

[DuncanC]

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-choice-filters/ba-...

[ALBJORGUI]

The issue is, how can I cascade anything if the initial country comes from a csv and not from a list in my choices tab?

[DuncanC]

It works the same. 

[abureaux · Accepted solution]

@DuncanCis correct.

In case it's needed, I'll just leave this here for reference: Survey123 Tricks of the Trade: External choice lists