activities
latest
false
UiPath logo, featuring letters U and I in white

Productivity Activities

Last updated Dec 6, 2024

Quickstarts – Classic activities

Overview

The following are links to step-by-step instructions on how to use the Microsoft 365 classic activities. These guides help you create a working sample of the different activities so that you can verify the connection to your Microsoft 365 application and get familiar with the input/output datatypes.

Quickstart

Description

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

  1. Establishes a connection to your registered Microsoft 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).

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 365 application (Microsoft Office 365 Scope).
  2. Creates a new folder in your OneDrive to store a new workbook (Create Folder).
  3. Creates a new workbook in the new folder (Create Workbook).
  4. Renames the default "Sheet1" in the new workbook (Rename Sheet).
  5. Builds a new DataTable object to write to the worksheet (Build Data Table).
  6. Writes the created DataTable to the worksheet (Write Range).
  7. Verifies the Write Range activity by reading back the values (Read Range and Output Data Table).

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 365 application (Microsoft Office 365 Scope).
  2. Creates a new folder in your OneDrive to store a new workbook (Create Folder).
  3. Uploads a file to the new folder (Upload File).
  4. Gets the file uploaded file metadata ().
  5. Verifies the results of the Upload File and Get Item activities by sending you an email that includes a link to your uploaded file (Send Mail).

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 365 application (Microsoft Office 365 Scope).
  2. Searches for and returns emails that match your search query (Get Mail).
  3. Moves the retrieved email to a different folder (Move Mail).
  • Overview

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.