Update rows

Use the Tables - Update rows action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. to update one or more rows of a Nintex table.

Note: The maximum number of rows that can be updated in a table using the Update rows action is 1000.

For more information about Nintex Tables, see Tables.

Configure the Tables - Update rows action

1. Add the action to the workflow and open the action configuration panel. For more information, see Add an action to the workflow.

2. Select the table you want to update in Table name.
3. Click Add columns to select columns and set values for the row.

   Important: Ensure that you enter correct values for all the columns selected. For the action to succeed and rows to be updated, all values must pass validation. If one fails validation, the action will fail.

4. Select the column to set a value and click Add.

5. Click Add conditions to define conditions and specify which rows you want to update.

   The Condition builder panel is displayed.

6. Fill the When, Operator and Value fields for the condition.

7. Create or select a variable to store the action output in Result.

Tables - Update action fields and settings

Section	Field	Description	Variable types
Table	Table name	The name of the table update.	Text, Decimal, Integer, Boolean, DateTime, Collection
	Add column	Select columns to set values for the row. All columns of the table are available for selection, except for the default Metadata columns and Date type columns.	(varies)
Conditions	Add conditions/Edit conditions	Define conditional statements. Displays the condition builder to define new conditions or edit existing conditions. Add conditions - Displayed when there are no existing conditions specified for the action. Edit conditions - Displayed when there are existing conditions set for the action. You can edit the conditions. The Condition builder supports nested conditions, enabling you to create conditions within another condition. For more information on the condition builder and the fields, see Condition builder.	(n/a)
Output	Result	Stores the result of the action as an object with the following variables: Updated row count(Integer)The number of rows updated.	Object