Update row item

This activity allows the user to update the value of a specific row in the specified DataTable.

Properties

Input

DataTable*: Specifies the input DataTable in which the row value must be updated. It accepts values in  DataTable variable.

Row*: Specifies the DataRow to be updated and accepts values in DataRow variable where the new value will be applied.

Value*: Specifies the new value to be assigned. It accepts a String data type, and you can provide the value directly in string format.

Misc

Display Name: The display name of the activity. This can be customized to make workflows easier to understand and troubleshoot.

SkipOnError: Specify the “Boolean” value as “True” or “False.”

True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

Output

Datatable: Returns the output with the updated row in a structured table format with the input provided.

Result: This parameter allows you to view the execution status of the activity and returns a value in “Boolean.”

True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown

* Represents mandatory fields to execute the workflow.

How to Get DataRow?

The Update Row Item activity requires an input of type DataRow. To retrieve a DataRow variable, follow the steps below:

1. Create or obtain a DataTable variable. Use activities that generate or extract a DataTable.
2. Add a For Each Row activity to iterate through the DataTable. This loop provides each row as a DataRow variable.
3. Use the DataRow variable within the loop as the input for the Update Row Item activity.