# Get Row Item

> `UiPath.Core.Activities.GetRowItem`

`UiPath.Core.Activities.GetRowItem`

Retrieves a value from a row in a DataTable according to a specified column.

## Project compatibility

**Windows** | **Windows - Legacy**

## Configuration

* **Row** - The name used to reference the DataTable row from which a value is read. The default value is `CurrentRow`.
* **Column** - Specify either the column number (index) or name from which the DataTable rows should be read. In **StudioX**, you can use the **Plus** ![](https://dev-assets.cms.uipath.com/assets/images/activities/activities-image-plus_menu-8e75b25b.png) icon to select one of the available options:
  + **Number** - The number of the column whose rows should be read.
    - Notebook or a parent Excel file. For example, select an Excel file, and then select **Indicate in Excel** to indicate a cell from the file that contains the value.
    - **Ask when run** - Prompt for a number when the project is executed.
    - **Number** - Enter a numeric value.
    - **Open in Advanced Editor** - Enter a VB expression.
  + **Name** - The name of the column whose rows should be read. If this property is set, the **Number** option is ignored.
    - Data from the Project Notebook, a parent Excel file or Outlook account. For example, select an Excel file, and then select **Indicate in Excel** to indicate a cell from the file, or select an email in Outlook and then select a field in the email that contains the value.
    - **Ask when run** - Prompt for the column name when the project is executed.
    - **Paste from clipboard** - Paste a value that you previously copied to the clipboard in the project.
    - **Text** - Enter the name in the Text Builder.
    - **Open in Advanced Editor** - Enter a VB expression.
  + **Value** - The resulting value that was read. Click **Plus** ![docs image](https://dev-assets.cms.uipath.com/assets/images/activities/activities-image-plus_menu-8e75b25b.png) on the right side of the field, and select **Copy to clipboard** or **Save for Later Use** to store the value for later use in the automation.

## In the Properties Panel

#### **Options**

* **Column** - The DataColumn object whose value is to be retrieved from the DataRow. If this property is set, the ColumnName and ColumnIndex properties are ignored.
* **ColumnIndex** - The index of the column whose value is to be retrieved from the `DataRow`.
* **ColumnName** - The name of the column whose value is to be retrieved from the `DataRow`. If this property is set, then the ColumnIndex property is ignored.
* **Row** - The DataRow object from which a value is to be retrieved.
* **DisplayName** - The display name of the activity.
* **Private** - If selected, the values of variables and arguments are no longer logged at Verbose level.

#### **Output**

* **Value** - The column value from the specified DataRow.

## Example of using the Get Row Item activity

[Here](https://docs.uipath.com/activities/other/latest/workflow/remove-data-row-column) you can see how the **Get Row Item** activity is used in an example that incorporates multiple activities.