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
