Updated Cell

Start the flow when data within a cell is updated.

Caution

Due to third-party API limitations, this event card doesn't monitor workbooks that are stored in OneDrive shared libraries. Flows are triggered for workbooks that are stored in personal OneDrive storage only.

If a workbook is moved from personal OneDrive storage to a shared library, the Microsoft API may continue to return the data for the version of the file at the time when it was moved. If the file is moved back to personal storage, the Microsoft API may return data for both the original file and the updated file after it was moved back 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, 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

Cell Reference Reference for a cell in a worksheet. For example, A1 for the first cell in the spreadsheet.

Text

TRUE

Output

Field Definition Type
Cell Value Value of the cell.

Text

Cell Text Text in the specified cell.

Text

Type

Type of data returned.

Text

Format Format for content in the cell.

Text

Hidden Indicates if the cell is hidden.

True/False

Column Hidden Indicates if the column is hidden.

True/False

Row Hidden Indicates if the row is hidden.

True/False

Formula Excel online formula.

Text

Related topics

Excel Online connector

Workflow elements

Guidance for Excel Online connector

Excel Online API documentation