Create WorkBook

Creates a new Excel workbook in the parent directory

This activity creates a new excel workbook with a user-specified name at a user-specified parent directory using the Microsoft Graph Upload item API.

Input

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

• Name: String Argument Required Specifies the name of the excel workbook that is to be created.

• Parent Drive Item: Object Argument Specifies the DriveItem of the parent directory in which the workbook is to be created. If left blank the workbook will be created at the root of the drive. We can also specify the output variable of Find Files And Folders activity (which is First or Results) directly as input in this property. 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].

• Conflict Behavior: Specifies a conflict resolution behavior in a case where a workbook with the same name already exists in the parent directory. The available options are:

  • Replace

  • Fail

  • Rename

Output

• Workbook:DriveItem Variable Required Specifies the newly created workbook as a DriveItem.

• Workbook Url:String Variable Specifies the newly created workbook as a DriveItem.