UiPath Activities Guide

Lookup Data Table

UiPath.Core.Activities.LookupDataTable

This activity is available starting with v2018.2.

This activity enables you to search for a provided value in a specified DataTable and returns the RowIndex at which it was found. This activity can also help you return the value found in the cell that has the row coordinates specified in the RowIndex property and the column coordinates specified in the Target Column property category.

Properties

Common

  • DisplayName - The display name of the activity.

Input

  • DataTable - The DataTable variable in which you want to perform the lookup. This field supports only DataTable variables.
  • LookupValue - The value you want to search for in the specified DataTable variable. This field supports only strings and String variables.

Lookup Column

  • Column - The variable containing the column you want to search for. This field supports only DataColumn variables. Setting a variable in this property field disables the other two properties.
  • ColumnIndex - The index of the column you want to search for. This field supports only Int32 variables. Setting a variable in this property field disables the other two properties.
  • ColumnName - The name of the column you want to search for. This field supports only strings and String variables. Setting a variable in this property field disables the other two properties.

Misc

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

Output

  • CellValue - Optional. The value found in the cell that has the Row coordinates specified in the RowIndex property and the Column coordinates specified in the Target Column property category. This field supports only Object variables.
  • RowIndex - The Row index of the found cell, stored in an Int32 variable. This field supports only Int32 variables.

Target Column

  • Column - Specifying a DataColumn variable here returns the value of the cell found at the coordinates between this column and the value from the RowIndex property. This field supports only DataColumn variables. Setting a variable in this property field disables the other two properties.
  • ColumnIndex - Specifying a Column index here returns the value of the cell found at the coordinates between this column and the value from the RowIndex property. This field supports only Int32 variables. Setting a variable in this property field disables the other two properties.
  • ColumnName - Specifying a Column name here returns the value of the cell found at the coordinates between this column and the value from the RowIndex property. This field supports only strings and String variables. Setting a variable in this property field disables the other two properties.

Lookup Data Table


Suggested Edits are limited on API Reference Pages

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