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

[Thiago_Calcagni]

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…

[Thiago_Calcagni · Accepted solution]

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

[Marc_Dillon]

Thiago_Calcagniti:

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

That would indicate that [Nome] is NOT the key column in the “Troca” table.

[Thiago_Calcagni]

True, i have made same mistake before cause i forgot about these KEYS.
Thank you!

[Steve]

help.appsheet.com

FILTER()

Select rows of table or slice

help.appsheet.com

SELECT()

Gather column values from row in table or slice

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

How are FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() related? FILTER(), LOOKUP(), MAXROW(), and MINROW() are all built upon SELECT(), so they all share similar capabilities and limitations. FILTER("table", select-expression) is equivalent to: SELECT( table[key-column], (select-expression) ) LOOKUP(match-expression, "table", "match-column", "result-column") is equivalent to: ANY( SELECT( table[result-column], ([match-column] = (match-expression)) ) ) N…

[Thiago_Calcagni]

Thank you, this is a good material explaining the relation and how actually some expressionas are built in. I should spend some time looking into these TIPS also, not only the Help material.
Thank you !