Skip to main content
The Find Table Row(s) by Column action filters a header-based table and returns either the first match or every matching row. Multiple filters use AND logic: a row must satisfy all of them.

​
Inputs

Each filter has a Column Name, Match Mode, and—when required—a Search Value. Column names resolve to the closest header ignoring capitalization, within a small spelling distance.

​
Match modes

​
Outputs

Found is always available. Other outputs depend on Find Multiple Rows?:
| Output | Type | Description | | -------------- | ------ | -------------------------------------------- | | Found | Boolean| Whether a match exists. | | Row Data | Object | First matching row, or empty when not found. | | Row Number | Number | One-based sheet row, or empty when not found. |
Switching Find Multiple Rows? changes the node’s output shape. Recheck downstream connections after toggling it.

​
Example: find unpaid large invoices

Add two filters:
  • Status → Exact Value → Unpaid
  • Amount → Greater Than → 1000
Then pass Row Numbers to Update Table Row(s) or Delete Row(s).

​
Troubleshooting

Verify Header Row Number and inspect the header cells. The action allows small spelling differences but cannot infer unrelated names.
Numeric modes only match raw numeric cells. A number stored as text does not qualify, even if its displayed characters look numeric.