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.
What donโt you understand? List? Ref? Key? Referenced table?
See also:
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.
[product] is not the key column for the Product_Locations table
Thanks Simon. You are right, I change it to the key of the table and it works.
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |