Sequence of actions

Hi!

Im trying to pass a value throught various sheets.

Right now “ActualizarInventario” is working, but I dont know why the action “Actualizar salida de producto” is not working, any ideas?

Thanks!

I believe the issue is the expression you are using in “Referenced Rows”:

SELECT(Reportes[IDFecha],  [IDFecha] = [_THISROW].[IDFecha])

This expression must return row IDs for the “Reportes” table. Since the action runs against the table “Entradas y Salidos”, the column [IDFecha] cannot be both the row ID for “Reportes” AND the link back to “Entradas y Salidos”.

This expression should follow this pattern:

SELECT(Reportes[<<key column for Reportes>>],  [<<Reportes column with row key from Entradas y Salidos>>] = [_THISROW].[<<key column for Entradas y Salidos>>])
2 Likes

Thanks! Found that the problem was with [IdFecha] as you stated, that column were blank and was trying to get info from them lol.

Solved the problem! Thanks!

1 Like