Search Rows by Column

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

Options

  • Workbook(dropdown): a list of workbooks available to the account. Workbook is another word for your Excel files.

  • Worksheet(dropdown): a list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files.

  • Column to Search(dropdown) : The column the search will be conducted on.

  • Result Set(dropdown) : either the first matching row or all matching rows.

Input Fields

  • Column

    • Value(text) : The column value. This is the number displayed in Excel on the top of first row.

Output Fields

  • Result : rows that are search for.

See Also

Excel Online connector

About the elements of Okta Workflows

Excel Online API documentation