What is the difference between Table[Column] and Table.[Column]?

[FTong]

Hello,

Is there a difference between Table[Column] and Table.[Column] when trying to reference values from other tables?

If so, how do you use each case.

Is one a column list expression and the other is not? (See snipped from Appsheet documentation below)?

• from-dataset-column : The specification of the table or slice (the “data set”) to search and the column from which values are to be gathered, in the form: dataset-name [column-name] . For example, Orders[Order ID] . Although identical in appearance to a column list expression, this argument is not an expression.

[Marc_Dillon]

Felix.P_Tong:

Table.[Column]

…is not a thing. Where did you get that from?

help.appsheet.com

List from Table-Column Reference

Create a list from the values in a column of a table.

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…

help.appsheet.com

Dereference Expressions

Use a dereference expression to get a column value from the referenced row.

[SkrOYC]

Some help @Felix.P_Tong since you seem like a good guy:

1. ThisIsTable[OneColumn] = A list of all the values inside the field [OneColumn] on all the rows of ThisIsTable
2. [ColumnOfRefType].[OneColumnOnTheRefTypeTable] = The value from one of the columns of the table where [ColumnOfRefType] is pointing to
3. [ColumnOfListType][OneColumn] = A list of values from the table which [ColumnOfListType] is pointing to

[FTong]

SkryOYC:

Thank you for your help.

Makes things a more clear.

PS: Sorry for the delay in responding. I was stuck in a Caribbean Island construction site for a few weeks. (Weather was great, mosquitos were vicious …LOL).