The UiPath Integrations Guide

Welcome to the UiPath Integrations guide. You will find comprehensive guides and documentation to help you start working with UiPath Integrations, as well as support if you get stuck.

In order to download the solutions mentioned here please visit the official UiPath Go! Marketplace here.

*Note that only integrations built in-house at UiPath are detailed below. For a complete list of UiPath's technology partners, see here.

Create Workbook

Overview

The Create Workbook activity creates a new workbook (Name) and uploads it to a specified location (Parent) using the Microsoft Graph UploadDriveItem API.

After the workbook is uploaded, the activity returns a DriveItem object (Workbook) and a URL String (WorkbookURL) that you can use as input variables in subsequent activities.

How it works

The following steps and message sequence diagram is an example how the activity works from design time (i.e., the activity dependencies and input/output properties) to run time.

  1. Complete the Setup steps.
  2. Add the Microsoft Office 365 Scope activity to your project.
  3. Add an activity or run an external process that outputs a DriveItem object (e.g., Find Files and Folders, Create Workbook, Copy Item).
  4. Add the Create Workbook activity inside the Microsoft Teams Scope activity.
  5. Enter values for the Input properties.
  6. Create and enter DriveItem and String variables for the Output properties.
  7. Run the activity.
    • Your input property values are sent to the UploadDriveItem API.
    • The API returns the DriveItem and String values to your output property variables.

Properties

The values for the following properties are specified when adding this activity to your project in UiPath Studio.

Common

DisplayName

The display name of the activity.

Attributes
Details

Type

String

Required

Yes

Default value

Create Workbook

Allowed values

Enter a String or String variable.

Notes

N/A


Input

Name

The name for your new workbook.

Attributes
Details

Type

String

Required

Yes

Default value

Empty

Allowed values

Enter a String or String variable.

Notes

N/A


Parent

The folder that you want to upload and save your new workbook to.

Attributes
Details

Type

DriveItem

Required

Yes

Default value

Empty

Allowed values

Enter a DriveItem variable.

Notes

  • Use the output property variable from
    the Find Files and Folders (First or Results) (see example image below).
  • If you're using the Results output property from the Find Files and Folders activity, specify the item in the array that you want to use (e.g., myWorkbooks(0))

Output

Workbook

The DriveItem object the represents your created workbook.

Attributes
Details

Type

DriveItem

Required

No (recommended if you plan to use the output data in subsequent activities)

Default value

Empty

Allowed values

Enter a DriveItem variable.

Notes

  • Enter a DriveItem variable that is different than the one used in the Parent property.

WorkbookURL

The URL to the new workbook in the Parent folder.

Attributes
Details

Type

String

Required

No (recommended if you plan to use the output data in subsequent activities)

Default value

Empty

Allowed values

Enter a String variable.

Notes

N/A


Misc

Private

If selected, the values of variables and arguments are no longer logged at Verbose level.

Attributes
Details

Type

Checkbox

Required

No

Default value

Not Selected

Allowed values

Selected or Not Selected

Notes

N/A


Example

The following image shows an example of the activity dependency relationship and input/output property values.

For step-by-step instructions and examples, see the Quickstart guides.

Updated 3 months ago


Did this page help you?