Default selected row in drop down not working

[Kosenurm]

Hi there, 

I have a label which contains a value limited by comma.... so "A,B,C"

I have drop downs which use the split function to put A, B, C into rows.

I want to change the default of the drop down to the first, second and third rows (A being row 1, B being row 2 etc). So I have changed the Defaults to "1", "2", and "3".... but the dropdowns continue to just display the first row only.

Any ideas?

Thanks

K

[BCLS776 · Accepted solution]

Try this:

Last(
    FirstN(
        Split(Label1.Text,",")
        ,2 // Change this number to select which item in the Split list you want
    )
).Result

Is that what you are after?

Bryan