I have the following setup:
Table 1 :
Action A: Update Table2 Column 3
Action A setup:
Do this: Data: execute an action on a set of rows
Reference table: Table 2
Referenced Rows:
FILTER("Table 2", AND([Column 1]=[_THISROW].[Column 1], [Column 2]=[_THISROW].[Column 2]) )
Referenced Action: Action B
Table 2:
Action B: Increment Column 3
Action B setup:
Do this: Data: set the values of some columns in this row
Set these columns: Column 3 = [Column 3] + 1
Issue:
Form Saved
If I set Table 1's Action A as a Table 1_Form's Form Saved behavior - Action Runs
Automation Bot
If I instead, create an automation bot using the same setup
Run action on rows
Referenced table: Table 2
Referend rows:
FILTER("Table 2", AND([Column 1]=[_THISROW].[Column 1], [Column 2]=[_THISROW].[Column 2]) )
Referenced Action: Action B
The action doesn't fire
Why?
What's even more interesting is if I change the Referenced Rows of the automation bot into
Table 2[KEY], the action runs. but I can't use this as it triggers the action on All Rows of Table 2.
What's going on here?
Solved! Go to Solution.
I figured out what to do (sort of).
This is what I did, in the bot step that runs action in set of rows, I turned on linking to make step reusable.
Then the bot step turns into a dropdown in which I was able to select the Recalculate action behavior I created. Before saving, I switched to behavior page and saw the new action that the bot created. I renamed it, set icons, etc, then came back to the Bot page then saved it.
After this, I didn't need the action behavior I created doing the same action in set of rows. This is now cleaner for me.
User | Count |
---|---|
18 | |
9 | |
8 | |
5 | |
5 |