Delete Rows

Deletes rows from a table.

This activity deletes the specified rows from a user-specified table in the given workbook using the Microsoft Graph Delete table row API.

Input

• Connection Id: GraphServiceClient Variable Required Specifies the office 365 connection id.

• Table Name: String Argument Required Specifies the name of the table from which the rows are to be deleted.

• Rows: String Argument Required Specifies the rows in the specified table that are to be deleted as String.

The rows input can be specified as the following:- "1" - Row 1 "1-5" - Rows 1 to 5 "1,4,6" - Rows 1,4,6 "1,3,5-9,12" - Rows 1,3,5 to 9 and 12

• Workbook: Object Argument Required Specifies the DriveItem of the Excel workbook that contains the table from which the specified rows are to be deleted. We can also specify the output variable of the Find Files And Folders activity (which is First or Results) directly as input in this property or use the output variable of the Create Workbook activity (Workbook). If we are using the Results property of the Find Files And Folders activity then we can directly specify the element in the array. For example : Results[1].