Webhook in Workflow Expression for Multiple Columns

[WilsonWee]

Hi there,

I know I can add rows using webhook with a body expression as follows:
“Rows”: [
<<Start: Select(Dimension[DimensionID], IN([DimensionID],[_THISROW].[DimensionList]))>>
{
“DimensionID”: “<<[DimensionID]>>”,
“DimensionNo”: “<<UNIQUEID()>>”,
“InspectDetailID”: “<<[InspectDetailID]>>”,
“CheckingItem”: “<<[Checking Item]>>”
},
<>
]

Question is what if I would also like to reference the key columns [DimensionID] to another table “Dimension” and retrieve [Checking item] from the same table “Dimension”?

Thank you.

[Steve · Accepted solution]

help.appsheet.com

LOOKUP()

Get column value from row in table or slice