UiPath Integrations

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.

Quickstart - Find, Create, and Add

Overview

The purpose of this guide is to help you create a working sample that uses different Microsoft Office 365 activities, including the Find Files and Folders, Create Workbook, Add Sheet, and Get Sheets activities.

After completing the steps in this guide, you'll have an automation sequence that does the following:

  1. Establishes a connection to your registered Microsoft Office 365 application (Microsoft Office 365 Scope).
  2. Finds an existing folder in your OneDrive to store a new workbook (Find Files and Folders).
  3. Creates a new workbook in the found OneDrive folder (Create Workbook).
  4. Adds a new sheet to the newly created workbook (Add Sheet).
  5. Tells you when the workbook and sheet have been created (Message Box) activity.
  6. Tests that your new sheet was added (Get Sheets and Write Line).
Quickstart message sequence diagram (how it works)

Quickstart message sequence diagram (how it works)

Prerequisites

Before you begin:

  1. Complete the Microsoft Office 365 Setup steps.
  2. Create or use an existing folder in your OneDrive. You'll use this folder to store the workbook you create in the steps below.
    • You can create a new folder manually or follow the Create, Write, Read Quickstart guide.

Steps

Build your project

  1. Add the Microsoft Office 365 Scope activity to your project.
    1. Enter the ApplicationId for your registered application (for more information, see the Setup guide).
    2. From the AuthenticationType drop-down list, select the applicable type (e.g., InteractiveToken).
      • If you select InteractiveToken and run the sequence while you're present, you don't need to add a Password, Tenant, or Username in the Unattended section (leave empty).
    3. From the Services drop-down list, select, at a minimum,Files.
  2. Add the Find Files and Folders activity after the Microsoft Office 365 Scope activity.
    1. Enter a Query (e.g., the folder name) to find the folder that you created, or are using, from step 4 in the prerequisites above (e.g., "Quickstarts").
    2. Create and enter a DriveItem variable for your First value (e.g., firstResult).
      • When creating your variable, select Microsoft.Graph.DriveItem as the variable type.
      • When your Query is specific, with no chance of finding more than one result, you can use the First output property only. When your Query is less specific you can add a DriveItem[] variable for your Results value to return all folders that meet the query parameters.
  3. Add the Create Workbook activity after the Find Files and Folders activity.
    1. Create and enter a String variable for your Name value (e.g., workbookName).
    2. In the Parent property, enter the DriveItem variable you created for the Find Files and Folders activity (e.g. firstResult)
    3. Create and enter a DriveItem variable for your Workbook value (e.g., newWorkbook).
  4. Add the Add Sheet activity after the Create Workbook activity.
    1. Create and enter a String variable for your Sheet value (e.g. _sheetName__).
    2. In the Workbook property, enter the DriveItem variable you created for the Create Workbook activity (e.g. newWorkbook).
  5. To indicate when the robot finishes the first set of activities, add the Message Box activity after the Add Sheet activity.
    1. Enter a String message (e.g., "Created "+workbookName+" and added "+sheetName)

Test your project

  1. Test that your new sheet was added to the created workbook, add the Get Sheets activity after the Add Sheet activity.
    1. In the Workbook property, enter the DriveItem variable you created for the Create Workbook activity (e.g. newWorkbook).
    2. Create and enter a String[] variable for your Sheets value (e.g., workbookSheets).
  2. Verify your sheet was found by adding a Write Line activity after the Get Sheets activity.
    1. In Text property, enter a message that includes the String[] variable you created for the Sheets property (e.g., "Verified "+workbookSheets(1)+" was added!").
      • Because the variable is an array, you must specify the item you want to output by appending an integer value at the end (e.g., (1)).
      • In this example, you want to return the 2nd sheet from the workbook because the Add Sheet activity adds the new sheet at the end of existing sheets - when the new workbook the first sheet (i.e., "Sheet 1") was added by default.
  3. Click Run and verify the Output window includes the face detail values you entered in the Write Line activity (e.g., AddSheetExample).

You're done!

When you're ready, try the other Quickstart guides to get more familiar with the different Microsoft Office 365 activities.

To learn more about the other Microsoft Office 365 activities, see the Activities page for a complete activity list and links to the activity detail pages.

Updated 3 months ago


Quickstart - Find, Create, and Add


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.