Using [_THISROW_BEFORE] & [_THISROW_AFTER] in automation action referenced rows filter expression

Hello,

I have an Inventory table and a bot which triggers on all changes to this table. The purpose of the bot is updating column [Amount] of some rows of  this table it self(Inventory).  So in order to achieve this I have got a step in my bot with a type of Run a data action and a custom action of type Run action on rows. The actions Referenced table is  set to Inventory, Referenced rows is set to the expression:  

SELECT(Inventory[Inventory ID], AND(OR([Item ID] = [_THISROW].[Item ID], [Item ID] = [_THISROW_BEFORE].[Item ID]), [Date] >= [_THISROW].[Date]))

But this only updates rows that have [Item ID] same as [_THISROW].[Item ID] not [_THISROW_BEFORE].[Item ID].

FYI: I don’t know if this has anything to do with the problem. Table Inventory rows are never created, edited or deleted in a form. They are created and updated in a form saved event action of other table. And deleted by a bot.

Solved Solved
0 5 1,343
1 ACCEPTED SOLUTION

5 REPLIES 5
Top Labels in this Space