Row Added or Updated

Start the flow when a new row is added or updated to the worksheet.

Note:

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 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

Output

Field	Definition	Type
Row
Row Number	Number of the row Added or Updated; this is the number displayed in Excel to the left of the first column.	Number
Values	List that represents each column in the row that was added or updated.	Text