Activities
latest
false
Banner background image
Productivity Activities
Last updated Mar 27, 2024

Technical references

The following table includes a list of each Microsoft 365 classic activity with the Microsoft Graph API it uses and the activity description.

You do not need to be familiar with the Microsoft Graph APIs to use the activities. These links are for informational purposes only in case you want to learn more about the action happening behind-the-scenes.

Excel

Activity

API Reference

Description

Adds a new worksheet to a specified workbook.

Writes a range of cell data to a specified workbook worksheet.

Copies an existing worksheet in a specified workbook and then pastes it as a new worksheet into the same or a different workbook.

Creates a new workbook and uploads it to the specified location.

Deletes a range of cell data from a specified workbook worksheet.

Retrieves the color properties of specified cells in a workbook worksheet.

Retrieves and returns an array of worksheets from a specified workbook.

Retrieves the value of a specified cell in a workbook worksheet.

Retrieves values from a specified column in a workbook worksheet.

Retrieves values from a specified range of cells in a workbook worksheet.

Retrieves the values of cells from a specified row in a workbook worksheet.

Changes the name of a specified workbook worksheet from its current name to a new name.

Writes a value to a specified cell in a workbook worksheet.

Writes a range of cell data starting from a specific cell in a specified workbook worksheet.

Clears values, format, fill, border, etc. of a range from the specified sheet.

Copies a range and pastes it to another location.

Sets the background color of a specified range.

Creates a table from the specified range.

Retrieves the range associated with the specified table.

Inserts a new column in a table. The previous column at the indicated position is shifted to the right.

Deletes a column from a table.

Inserts rows at the specified position in a table. Any rows below the inserted rows are shifted downwards.

Deletes the specified rows from a table.

Finds a value in a range using the VLOOKUP function.

Files

Activity

API Reference

Description

Creates a copy of a file or folder and adds it to the same or a new parent folder.

Creates a new folder in a specified parent directory.

Deletes a specified item (e.g., file, folder) in your OneDrive or SharePoint site.

Downloads a specified item (e.g., file, folder) in your OneDrive or SharePoint site.

Converts a OneDrive or SharePoint file to a PDF and saves it to a local location.

Finds the files, metadata, and/or contents that match the values of your search parameters.

Gets the metadata of a specified item with a known ID.

Moves a specified file or folder to a new parent folder with the option to change its name.

Uploads a local file to your OneDrive or SharePoint site.

Shares a file or folder drive item with the specified recipients.

Performs an activity or a series of activities on each file/folder that matches the filter criteria.

Outlook

Activity

API Reference

Description

Forwards a message, with additional content, to one or more recipients.

Retrieves the messages that match your search parameters from a specified mailbox.

Moves a message to a different mail folder.

Replies to a specified message.

Send a message to one or more recipients.

Deletes an email message.

Associates categories with a message.

Calendar

Activity

API Reference

Description

Adds an attachment to a specified event.

Adds an attendee to a specified event.

Adds a location to a specified event.

Creates a new event in a specified calendar.

Deletes a specified event.

Suggests meeting times and locations based on organizer and attendee availability and your specified range of time that you want the meeting to occur.

Retrieves the properties and relationships of a calendar.

Changes an existing event.

Responds to a specified event.

Retrieves the events that match your search parameters from the specified calendar.

Groups

Activity

API Reference

Description

Creates a new group.

Deletes an existing group.

Gets a Microsoft 365 Group.

Lists all the groups in an organization, including but not limited to Microsoft 365 Groups.

Planner

Activity

API Reference

Description

Creates a new bucket inside a plan.

Deletes a specific Planner bucket.

List all the buckets from a specific plan.

Lists all the tasks in a bucket.

Creates a new plan.

Retrieves the plan given its ID.

Retrieves the entire list of plans from a specific Group.

Creates a new task.

Deletes an existing task.

Gets a specific task.

Lists all the tasks from a specific plan.

Updates an existing task.

SharePoint Lists

Activity

API Reference

Description

Performs an activity or a series of activities on each list in the specified SharePoint site.

Gets information about the specified SharePoint List.

Performs an activity or a series of activities on each list item in the specified SharePoint list.

Deletes the specified list item.

Adds one or multiple list items to the specified SharePoint list.

Updates the specified list item.

  • Excel
  • Files
  • Outlook
  • Calendar
  • Groups
  • Planner
  • SharePoint Lists

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.