SELECT's filter-column name conflicts with the column name in START expression loop

[devmasadajaya]

Hi there,

I have a table recording items in an inventory adjustment, the table is called "Inventory Adjustment Items", whose columns are:

1. Adjustment Id
2. Inventory Item Id
3. Quantity

I also have a table called "Inventory Adjustments" recording the inventory adjustment itself, which has columns:

1. Adjustment Id (as a key and reference to the Inventory Adjustment Items table)
2. Department
3. Section

Finally, I also have a table, called "Inventory Stock Balances", recording the latest inventory quantity snapshot for a Department, Section, and Inventory Item Id combination.

I try to create a webhook API action as follows:

<<START: [Related Adjustment Items]>>
{
  "Department":"<<[_thisrow].[Department]>>",
  "Section":"<<[_thisrow].[Section]>>",
  "Inventory Item Id": "<<[Inventory Item Id]>>",
  "Latest quantity": "<<
ANY(SELECT(Inventory Stock Balances[Latest quantity],
  AND([Department]=[_thisrow].[Department],
            [Section]=[_thisrow].[Section],
            [Inventory Item Id]=[Inventory Item Id]
), TRUE)) + [Quantity]>>",

}

<<END>>

The highlighted Inventory Item Id filter above (bold and italics) does not work. I think the expression is confused by the exact same name of the column filter and the column reference in the "Related Adjustment Items" loop.

Is there any way to fix this confusion? Basically, I want to increment the Inventory Stock Balance record matching the Department-Section-Inventory Item Id key with the quantity input in the adjustment item record.

Latest quantity = select latest quantity with the key + Quantity input.

Thanks in advance for your help,

-- Hendi