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! Go to Solution.
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |