Bot doesn't work

[Cannone_Cannone]

Hi everyone!!
give me a hand to understand where I'm wrong, thanks to the patience and help of Alyssa_QREW
I managed to create my first Bot, the problem is that it still doesn't work. I have two tables, a "Historical_Organization_Table" and the other "Training_List". When I change a value in a column of the "Historical_Organization_Table" I would like it to also change all the fields associated with that employee.The action I created works for every single row, mail Bot doesn't work.the formula I'm using for the bot

SELECT(ELENCO_TRAINING[key],[Area]=[_thisrow].[Area])

in the table "Organico Storico" the key is' (id employee)  In the "Training List" table (key with uniqueid() formula

thanks a lot

[lynchk21 · Accepted solution]

Here are the step I would follow:

1. Create a new bot
2. When this EVENT occurs:
   1. Data Change
   2. Table: Tbl_Organico_Storico
   3. Date change type: Updates
   4. Condition: [_thisRow_Before].[Area]<>[_thisRow_After].[Area]
3. Run this PROCESS
   1. Run a data action
   2. Run action on rows
   3. Referenced Table: ELENCO_TRAINING
   4. Referenced Rows: [_thisRow].[Related Tbl_Organico_Storicos]
   5. Referenced Action: Aggiungi in Training Record