Power Platform Community Forum Thread Details

Hello,

Could you please help me with one problem?

Why this is working:

AddColumns(
 'Price List Items',
 "PriceListName",
 LookUp(Products, Product='Price List Items'[@Product].Product, 'Default Price List'.Name))

But this is not?

AddColumns(
 Products,
 "Amount",
 LookUp('Price List Items', 'Price List Items'[@Product].Product=Product, Amount))

The error is:
"The function LookUp has some invalid Arguments, Column Price List Items is not accessible in this context".

Thank you very much.

Categories:

Strange 'Price List Items' behavior in lookup