Change a column value of a referenced table using value from this row

I know that we have the feature “Execute an action on a set of rows” …
I am trying to do something really simple using it, but that just doesn’t work and can’t figure out.

Current Table 1 is Usuarios
Reference Table 2 is Troca

I wanna change the value of column Status of table Troca to “Autorizado”, only in the rows which have column “Nome” = Usuarios[_THISROW].[UserID]. The action is triggered from a row of table Usuarios. But that just doesn’t work…

Solved Solved
0 5 692
1 ACCEPTED SOLUTION

I used FILTER instead of SELECT and it worked … why ??

View solution in original post

5 REPLIES 5