Search Rows by Column

Search for a row or rows that match a value in a certain column.

Options

Field Definition Type Required
Workbook A list of workbooks available to the account. Workbook is another word for your Excel files. Dropdown FALSE
Worksheet A list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files. Dropdown FALSE
Column to Search The column the search will be conducted on. Dropdown FALSE
Result Set Either the first matching row or all matching rows. Dropdown FALSE

Input

Field Definition Type Required
Column
Value The column value. This is the number displayed in Excel on the top of first row. String FALSE

Output

Field Definition Type
Result Matching row/list of rows. String
Row ID Unique identifier of the row. Number

Related topics

Excel Online connector

About the elements of Okta Workflows

Excel Online API documentation