Subscribe

UiPath Activities

The UiPath Activities Guide

Get Row Item

UiPath.Core.Activities.GetRowItem

In the Studio profile, this activity is named Get Row Item.

Description

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

Properties

Input

  • Row - The DataRow object from which a value is to be retrieved.
  • 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.
  • 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.

Output

  • Value - The column value from the specified DataRow.

Common

  • DisplayName - The display name of the activity.

Misc

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Example of using the Get Row Item activity

Here you can see how the Get Row Item activity is used in an example that incorporates multiple activities.

UiPath.Core.Activities.GetRowItem

In the StudioX profile, this activity is named Read Row Item.

Description

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

Configuring the Activity

In the Body of the Activity

  • 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.
    • Number - The number of the column whose rows should be read. Click Plus plus button on the right side of the field, and then, from the menu, select the column using one of the available options:
      • Row - Select a column from the list. The number of columns displayed is based on the Column count property of the For Each Row in Data Table activity.
      • Data from the Project 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.
      • Number - Enter a numeric value.
      • Ask when run - Prompt for a number when the project is executed.
      • Use Saved Value - Select a value that you previously saved for later use in the project.
      • 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. Click Plus plus button on the right side of the field, and then, from the menu, select the column name using one of the available options:
      • Row - Select a column from the list. The displayed column names are the same names that you provided in the Header names property of the For Each Row in Data Table activity.
      • 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.
      • Use Saved Value - Select a value that you previously saved for later use in the project.
      • Open in Advanced Editor - Enter a VB expression.
  • Value - The resulting value that was read. Click Plus plus button 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

Common

  • DisplayName - The display name of the activity.

Input

Misc

  • Private - If selected, the data used in the activity is not logged by StudioX.

Output

Updated 5 months ago


Get Row Item


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.