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
Solved! Go to Solution.
Here are the step I would follow:
Looks like the error is in the access to the office365 data source. If that is the case, I am not much help.
Here are the step I would follow:
Hi, thank you very much for your help, I tried but I get this error, plus "tbl_organico Storico" is a table not a column
When you create a reference in your child table (ELENCO_TRAINING) using the [id employee] column, it should generate a reference column in your tbl_organico Storico table. This column will be called something like "Related XXXX" and have a formula of REF_ROWS("Elenco_Training","id employee") - maybe it is called [Related Elecno_Trainings]. This is the column to use.
Oh sorry - this is not on the right table. For referenced rows you can try SELECT(Elenco_Training[area],[id employee]=[_thisRow].[id employee])
Hi I changed with
[_thisRow].[Related Elenco_Trainings] takes the formula, but when the value in the "historical organic tbl" table changes in the "training list" table nothing happens. I really don't understand where the problem is
have you tried: SELECT(Elenco_Training[area],[id employee]=[_thisRow].[id employee])
Tried this too and nothing works๐ญ
I'll give you these too
I tried to do a test
Looks like the error is in the access to the office365 data source. If that is the case, I am not much help.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |