How to display Drop down list Virtual Column

[Afaq]

hi
I have created a virtual column and wanna populate it from an other table column values as drop down list, it populate with values but not displaying as drop down list and displays as consecutive paragraph text where as if i use any physical column instead of Virtual Column it appears fine.

[Marc_Dillon]

Virtual Columns cannot be used to get user input, thus they cannot show drop downs. Are you just trying to display a list of values nicely? You could use a LongText VC with your same expression to gather the List of values, then use SUBSTITUTE to change commas into line breaks.

SUBSTITUTE( #original-expression# , "," ,"
")

If you’re wanting to get user input, you need to use a real column.