Find Data Row

Find Data Row

Type: find-row  ·  Package: DataTable Activities v1.0.0  ·  Output: DataRow

Returns the first row of a DataTable that matches one or more conditions, or null if none match. It does not modify the table.

How it works

The conditions are built visually with the conditions editor — the same as Filter DataTable: each condition is column / operator / value, combined with AND or OR logic. The activity walks the rows and returns the first one that matches.

Available operators: equals, not-equals, contains, starts/ends with, greater/less than (or equal), is empty / is not empty.

Required parameters

Parameter	Editor	Description
table	expression	The DataTable to search, e.g. = customers.
conditions	conditions	Match conditions (column/operator/value) with AND/OR.

Optional parameters

None.

Output

Returns the first matching DataRow, or null if none matches.

Example

Find the first VIP customer with a high balance and notify:

Find Data Row   table = = customers   conditions: Type equals "VIP"  AND  Balance greater-than 10000   → output: customer

If   condition = = customer != null
 ├─ then:
 │    Get Cell   row = = customer   column = "Email"   → output: email
 │    SMTP Send  to = = str(email)   subject = "Priority attention"
 └─ else:
      Log   message = "No customer matches"

Always check whether it found something

If no row matches, the output is null. Validate with = row != null (as above) before reading cells, to avoid failing when accessing a non-existent row.

Related activities

• Filter DataTable — keep all matching rows (not just the first).
• Get Data Row — get a row by index instead of by condition.
• Get Cell — read a cell of the found row.