Automation is repeated for each row in the table

[suzukixxx]

For example, let's say you have a fixed cost table and an expense table, and the fixed cost table has "item (text)", "amount (price)", and "status (yes/no)". You want to use the automation sucheduled to transfer the items with a status of "Y" in the fixed cost table to the expense table at the beginning of the month.
This works perfectly if you do it with just the action button.
Specifically, you create two actions, one is "execute an action on a set of rows" and the other is "Add a new row to another table using values ​​from this row".
In the first Referenced Rows, you enter "select(fixedcost[fixedcostID], [status] = "Y")".
However, if you use the automation sucheduled, it will behave strangely. For PROCESS, select "run action on rows" and enter "select(fixedcost[fixedcostID], [status] = "Y")" in Referenced Rows. When you do this, for some reason, the rows with a status of Y are selected, but this is repeated for each row in fixedcost. In other words, even if there is only one row with a status of Y for, say, "Mobile phone bill," if there are 10 rows in the table, 10 rows for "Mobile phone bill" will be inserted.
I would like to know what I'm doing wrong.

[Joseph_Seddik]

You might need to disable the ForEachRowInTable option in your bot's Event. 

[suzukixxx]

Thanks.
When I do that I can't select "run a data action".
Can I achieve the same behavior if I turn off ForEachRowInTable?

[VarunChandran · Accepted solution]

Enable ForEachRowInTable and put a filter condition for which row you want to trigger the automation. Because If you enable FOrEachRowInTable and not give any filter condition then it will triggerred for all rows. Try to apply filter condition.

[suzukixxx]

Thank you. I haven't fully understood it yet, but the problem I was having was solved by the method you suggested.
When I entered [status] = "Y" there, the desired behavior was obtained. I thought I had tried this.
I appreciate it.