How to setup Action to change value of a column

[etiennechourreu]

I everyone, this is my first post, thanks for having me.

I am trying to setup an action that would change the values in a column (YES/NO).

Action Name : Start a new Stocktake Session
For a record on this table : tb_Inventory
Do This: Data: execute an action on a set of rows
Referenced table: tb_Inventory
Referenced rows: SELECT(tb_Inventory[Inventory_ID], [inventoryUpdateNow] = FALSE)
Referenced Action: Set inventoryUpdateNow to True

Action Name: Set inventoryUpdateNow to True
For a record of this table: tb_inventory
Do This: Data: set the values of some columns in this row
Set these columns: inventoryUpdateNow = true

When trying to start this action, I get an error : Unable to update row in table 'tb_Inventory'. → Invalid request provided to AppSheet database

I don't really know what I am missing.

Thanks for your help.

[AleksiAlkio]

Your actions and their strutures seem to be fine. few things to check..
- Is the [inventoryUpdateNow] editable?
- Is the tb_inventory table and its updates allowed?
- Is the [Inventory_ID] a key column in tb_Inventory table?
- Have you tried to use TRUE instead of true? It should not matter but just in case.