This is a tricky one.
I have a workflow and set of actions that update a column in a referenced table. Works fine for additions and updates.
However, I want to blank out the column in the referenced table row when the row in the referencing table gets deleted.
I guess the expression (shown below) to kick off the update from the row being deleted no longer has the reference, and therefore cannot kick off the update to blank the column out.
SELECT(Items[Item ID], [Item ID] = [_THISROW].[Item ID])