Insert Column

Inserts a new column to the table.

This activity inserts a new column to the user-specified table in the given workbook using the Microsoft Graph Create Column API.

Input

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

• Table Name: String Argument Required Specifies the name of the table in which the column is to be inserted.

• Column Name: String Argument Required Specifies the name of the column to insert the column.

• Workbook: Object Argument Required Specifies the DriveItem of the Excel workbook that contains the table in which the specified column is to be inserted. 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].

• Position: Object Argument Specifies the relative position of the new column. If the field is left blank or if the specified value is greater than the index of the last column, the new column is added to the end and if the specified value is 0 then the column is added to the front.

• Column Values: DataTable Variable Required Specifies the values that are to be added in the new column as a DataTable containing a single column.