# Insert Column

> `UiPath.MicrosoftOffice365.Activities.Excel.InsertColumn`

`UiPath.MicrosoftOffice365.Activities.Excel.InsertColumn`

## Description

Uses the Microsoft Graph [Create Column](https://docs.microsoft.com/en-us/graph/api/table-post-columns?view=graph-rest-1.0&tabs=http) API to insert a new column in a table. The previous column at the indicated position is shifted to the right.

### Scopes

This activity requires the following scopes:

* Files.ReadWrite

OR

* Files.ReadWrite.All

OR

* Sites.ReadWrite.All

## Project compatibility

Windows - Legacy | Windows

## Configuration

**Properties**

#### Common

* **DisplayName** - The display name of the activity. This property supports `String` variables and string formatted values.

#### Input

* **Column Name** - The name of the new column to insert. This property supports `String` variables and string formatted values.
* **Column Values** - The values to add in the new column, specified as a DataTable containing only one column. This field supports only `DataTable` variables.
* **Position** - The relative position of the new column. If left blank or if the value is greater than the index of the last column, the column is added to the end. If the value is less than 0, it is added to the front. This field supports only integer and `Int32` variables.
* **Table Name** - The name of the table. This property supports `String` variables and string formatted values.
* **Workbook** - The Drive Item of the Excel document. Use the [Find Files And Folders](https://docs.uipath.com/activities/other/latest/productivity/office365-find-files-and-folders) activity to retrieve this Drive Item. This field supports only `DriveItem` variables.

#### Misc

* **Private** - If selected, the values of variables and arguments are no longer logged at Verbose level. This field supports Boolean values.