“Execute an action on a set of rows” - In the referenced action, I want to select the changed-row’s column.
Here is the scenario: Update Stock.Quantity for each changed Row in InvoiceLines table.
So, i have defined a workflow in InvoiceLines tables which is to be triggered when any changes happens in InvoiceLines.
The workflow will change the data using an action on InvoiceLines table of type “Execute an action on a set of rows”. This action has:
Event (Changed) Table: InvoiceLines
Target (Referenced) Table: Stock
Rows on which to apply the action: SELECT(Stock[DesignNumber], [DesignNumber] = [_THISROW].[DesignNumber])
And, there is a Referenced Action:
Here is where I have trouble of updating. The update is: Stock.Quantity = Stock.Quantity -
I cannot access referenced row’s quantity (InvoiceLines.Quantity) within UpdateStock action.
How to achieve this?