How I get the first value from enum list

[Julio_Moyano]

Hi,

I have a EumList column. I would like to get the first selected value in the enumlist.
I tried using TOP(Table[Column], 1) in a virtual column , but I got the first value not the first selected value.

thanks!

[Marc_Dillon · Accepted solution]

Referencing a Column value in a Table, versus referencing ALL Column values in the entire Table Tips & Tricks 💡

Having answered this question about 1 million times now, I guess I should make a tips-and-tricks post about it. Expressions of the form Table[Column] return a List type data value that contains the values in Column for ALL records in the entire Table. Most likely, If I’ve referred you to this post, the answer to your question is simply to change it to just: [Column] One of the most common places I’ve seen new app builders use this, is within SELECT() expression, like: SELECT( Table[Col…

Also. TOP() returns a List, you probably want to use ANY() or INDEX(…,1) instead.

help.appsheet.com

ANY()

One arbitrary list item

help.appsheet.com

INDEX()

One specific list item

help.appsheet.com

TOP()

Initial list items

[Julio_Moyano]

Thanks Marc