Search Rows by Column
Search for a row or rows that match a value in a certain column of an Excel Online worksheet.
Due to third-party API limitations, this action card doesn't update workbooks that are stored in OneDrive shared libraries. Updates are limited to workbooks stored in personal OneDrive storage.
If you move a workbook from personal OneDrive storage to a shared library, the Microsoft API may continue to return the data of the version of the file at the time when it was moved. If you return the file to personal storage, the Microsoft API may return data for both the original file and the updated file after it was returned to personal OneDrive storage.
Options
| Field | Definition | Type | Required |
|---|---|---|---|
|
Workbook |
List of workbooks available in your account. Workbook is another word for your Excel files.
If you select a Workbook from the dropdown, ignore the Workbook ID field. If you select -- Enter Workbook ID -- from the dropdown list, then enter an ID in the Workbook ID field. |
Dropdown |
TRUE |
|
Workbook ID |
Option to specify a Excel Online workbook by ID. Example of a workbook ID: 015PGUOTTY6ZMVGBRB65DLDRED7VJJEJTP To get the ID for an Excel Online workbook, see Get a DriveItem resource. |
Text |
FALSE |
|
Worksheet |
List of worksheets available in the specified workbook. A worksheet is an individual spreadsheet within a workbook, displayed as a tab in an Excel file. |
Dropdown |
TRUE |
|
Column to Search |
Column on which the search will be conducted. |
Dropdown |
TRUE |
|
Result Set |
Either the first matching row or all matching rows. |
Dropdown |
TRUE |
Input
| Field | Definition | Type | Required |
|---|---|---|---|
|
Column |
|||
|
Value |
Column value. This is the number displayed in Excel on the top of first row. |
Text |
FALSE |
Output
| Field | Definition | Type |
|---|---|---|
|
Result |
Matching row or list of rows. |
Text |
|
Row ID |
Unique identifier of the row. |
Number |