Look Up Expression No Return Value

[reggieneo]

Hi All,
Why I can’t get any result in this expression:
LOOKUP([_THISROW].[Materials],“HW Products”,“Product Name”, “Price”)

Return Zero

My Product Table:

thanks

[hru]

Try to remove [_THISROW] and see if you can get the result. Did you place the expression in the initial value of the Unit-Cost column?

[reggieneo]

I tried it without the [_thisrow]. doesn’t work.
it is in initial value of Unit Cost.

I even used Any and select still no result. no error

[Suvrutt_Gurjar · Accepted solution]

Maybe you wish to try, assuming [Materials] is a reference column that references ,“HW Products” table,

LOOKUP([_THISROW].[Materials],“HW Products”,“Product Key”, “Price”)

Or if the table “HW Products” is referenced in the table where the form picture you have shared is based of, you may wish to also try

[Materials].[Price]

[reggieneo]

awesome Suvrutt!,
thanks.
this [Materials].[Price] does the trick

[Suvrutt_Gurjar]

Good to know it works. You may wish to take a look at the following article

help.appsheet.com

Dereference Expressions

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

[reggieneo]

will do. thanks