Run Action on a set of rows - Form Saved vs Automation bot

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 Solved
0 9 5,109
1 ACCEPTED 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.

View solution in original post

9 REPLIES 9
Top Labels in this Space