Webhoop edit select ComputedKey

Andy_strathmore · 09-25-2021 08:09 PM

ERROR MESSAGE
‘New process 5’ task ‘product_location_update’ Body template. Start expression ‘Select(Product_Locations[product], And([product]=[_THISROW].[product]), ([location] = [_THISROW].[location]))’ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the ‘Key’ column of the referenced table.

BODY

 "Rows": [
<<Start: 
Select(Product_Locations[product], 
            And([product]=[_THISROW].[product]), 
                   ([location] = [_THISROW].[location])
           )
>>
{
"quantity":"<<[quantity] - [_THISROW].[top_up_quantity]>>"
}
<<END>>
]

Target:
Find row in Product_Locations table which match the same product name and location, update new quantity.
I don’t understand the error
“Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the ‘Key’ column of the referenced table.”

Can anybody help?
Thank you.

Steve

What don’t you understand? List? Ref? Key? Referenced table?

See also:

Andy_strathmore

Hi Steve,
Thanks for you reply.

Does this message means the with my start expression, there is not list will be generate or the list is not having contents which are Ref value?

If it is, then any document which is explaining how to generate a list and the contents of the list are Ref values?

Looking forward to hearing from you.

1minManager

[product] is not the key column for the Product_Locations table

Simon@1minManager.com

Andy_strathmore

Thanks Simon. You are right, I change it to the key of the table and it works.