Hi guy I’ve a very problematic issue that stops my development. Can you help me please? Ok I have set an event with a condition on the table “Richieste”. The event correctly works. Now I need that when this event accurs a process set column “Start Credit” to “1000” in a referenced table “Utenti”. The Ref column that link the two table is “ID Utente”. I try to build these process/tasks but it doesn’t work.
In Referenced Rows field try
Filter(“Utenti”,[KeyColumnOfUtentiTable]=[_ThisRow].[ID_Utente])
Unfortunately @jyothis_m it doesn’t work. It this final action correct in your opinion?
I think it is correct. Have you tried finding what error has occured in the BOT monitor as well as Log Analyser
Dear @jyothis_m thanks for you patience. I haven’t seen error in bot monitor. I only find this log in “test” bot. What do you mean with “Log Analyser”?
I did it @jyothis_m but I don’t understand the detail log report. I can’t see the change that every task did in my columns
When you try to execute the action directly from the row is it getting executed correctly. Try both actions individually. First try the action Set values of some columns in this row and then the other actions. Could you pls try this.
Hey @jyothis_m I test every actions me and now… it works 
. Remains only an error because seem that the final action (see screenshot) doesn’t use the row result by the referenced row output from the filter above but the row with the same “row number” . I can’t explain me why. Can you help me please?
What is the name of Key Column of the referenced table.
I have set “ID Cliente” as a Ref column in the Table “Richieste” that links to a column named “ID Cliente” too in the “Utenti” table. Thanks for your help.
Dear @jyothis_m I’d like to add that the condition you suggest me returns the correct “ID utente” row but the referenced action seems doesn’t use this row but “Row number”.
which Row Number
The number automatically assigned to every row by the system…
Hi @Denis_Dal_Soler sorry i couldn’t understand what the exact issue. Can you pls give some screenshots of both table data
Let for easier understanding
ACTION 1 - set the value of some columns in this row - for Table-1
ACTION 2 - execute an action on a set of rows - for Table-2
When you execute Action 1 on Row-25 of Table-1, it is changing column of Row-25 of Table-1
When you execute Action 2 on Row-30 of Table-2 which has referece to Row-10 of Table-1, it is changing column of Row-10 of Table-1
Is this happening correctly. If not can you pls explain whats happening in your app with reference to this example.
Dera @jyothis_m forgive me. What do you mean with “Execute Action 1 on Row-25 of Table-1”? I don’t know how to do it.
You can make the Action Button Visible for both tables for testing so that you can got to the table row and execute the Action manually
Ok @jyothis_m , now I’ve understood
So,
The “ACTION 1 - set the value of some columns in this row - for Table-2 (Utenti)” goes well.
but “ACTION 2 - execute an action on a set of rows - for Table-2 (Utenti)” (see screeshot) is visible only in the process and I’m not able to run it in a specific row. However I don’t need that
When you execute Action 2 on Row-30 of Table-2 which has referece to Row-10 of Table-1, it is changing column of Row-10 of Table-1
But
When you execute Action 2 on Row-30 (Referenced row) of Table-2 (Referenced table) which has referece to Row-10 of Table-1 (thanks to your suggest filter condition) , it is changing column of Row-30 of Table-2
I hope to be clear.
Thanks
