- Get started
- Build
- HTTP Request
- How connector nodes work
- Create a connection
- Sales and customer relationships
- Customer support and help desk
- Messaging and meetings
- Email
- Marketing
- Social media
- Files, documents, and e-signature
- Projects, collaboration, and code
- People and recruiting
- Finance and commerce
- AI models and agents
- Speech, vision, and language
- Data and location
- Cloud, identity, and security
- Deploy and run
- Examples
- Reference
Microsoft OneDrive & SharePoint
Look up the Microsoft OneDrive & SharePoint connector: its actions and events in alphabetical order, and the sign-in methods of a Microsoft OneDrive & SharePoint connection.
The Microsoft OneDrive & SharePoint connector lets a workflow manage files, folders, SharePoint lists, and Excel workbooks in OneDrive and SharePoint. In the Add node panel, it's in the Connector category, under Microsoft OneDrive & SharePoint. How connector nodes work describes how a connector node is set up.
This page lists what the connector can do in Maestro Automate. Select an event to see its details in the Integration Service guide.
Actions
Each action is a node that does one thing in Microsoft OneDrive & SharePoint.
| Action | What it does |
|---|---|
| Add List Item | Add a new item to SharePoint List. |
| Add Sheet | Add a new sheet to the workbook. |
| Assign Sensitivity Label | Assign a sensitivity label to a file in OneDrive. |
| Copy File or Folder | Copy a file or folder to the specified destination folder in OneDrive or SharePoint. |
| Create Folder | Create a folder at the specified location in OneDrive or SharePoint. |
| Create Workbook | Create a new workbook in OneDrive or SharePoint Document Library. |
| Delete Column | Delete a column from a worksheet in workbook. |
| Delete File or Folder | Delete a file or folder at the specific location in OneDrive or SharePoint. |
| Delete List Item | Delete an item from a SharePoint List. |
| Delete Range | Delete data from specified range in workbook. |
| Delete Rows | Delete data from specified rows in workbook. |
| Delete Sheet | Delete a specified sheet from workbook. |
| Download File | Download a file or folder from OneDrive & SharePoint. |
| File Check-in/Check-out | Check-in or check-out a SharePoint file. |
| File or Folder Exists | Check whether a file or folder exists in OneDrive or SharePoint. |
| Get File or Folder | Get file or folder from OneDrive or SharePoint to use in other activities. |
| Get File or Folder by Sharing Url | Resolve a OneDrive or SharePoint URL into a Reference ID and other identifiers that other activities accept as input. |
| Get File or Folder List | Retrieve a list of files and folders from the specified OneDrive or SharePoint location. |
| Get File or Folder Metadata | Fetch metadata for a file from OneDrive & SharePoint. |
| Get List Items | Retrieve a list of items from a SharePoint List. |
| Get Sensitivity Labels | Retrieve the sensitivity labels applied to a file. |
| Get Single List Item | Retrieve a single item from a SharePoint List. |
| Move File or Folder | Move a file or folder to the specified destination folder in OneDrive or SharePoint. |
| Read Cell | Read the value of a cell in a worksheet. |
| Read Range | Read data from a range of cells in a worksheet. |
| Rename Sheet | Rename an existing worksheet in a workbook. |
| Share File or Folder | Share a file or folder. |
| Update File or Folder Metadata | Update metadata for a file or folder in OneDrive. |
| Update List Item | Update an item in a SharePoint List. |
| Upload File | Upload the specified file to OneDrive or SharePoint. |
| Write Cell | Write data into a specified cell of worksheet in workbook. |
| Write Column V2 | Write data into column in specified range of worksheet with advanced options. |
| Write Range | Write data into specified range in worksheet. |
| Write Row | Write data into row in specified range of worksheet. |
The panel also lists 5 actions marked (deprecated), which aren't listed here. Use the actions above instead.
Events
Each event can start a workflow, as a Connector trigger, or pause a run until it happens, as a Connector event. In the connector's list, events have the WAIT tag.
| Event | What it does |
|---|---|
| Cell in Worksheet Updated | Starts the automation when a cell within a Worksheet is updated. |
| File Created | Triggers when a new file is created in the drive. |
| File Moved to Trash | Triggers when an existing file is moved to trash from the drive. |
| File Updated | Triggers when an existing file is updated in the drive. |
| Folder Moved to Trash | Triggers when an existing folder is moved to trash in the drive. |
| List Item Added | When a new item is added to a SharePoint List. |
| List Item Updated | When an item is modified in a SharePoint List. |
| Row Added to the Bottom of a Table | When a row at the bottom of a table is filled in with appropriate columns as an optional data filter. |
| Worksheet Created | Starts the automation when a new Sheet within a Spreadsheet is created. |
Connection
A Microsoft OneDrive & SharePoint node signs in through a connection. Create a connection describes how to create one from the node. On the Connect to page, choose one of these sign-in methods:
| Sign-in method | What you need |
|---|---|
| OAuth 2.0 Authorization code | Your Microsoft account. It uses the UiPath public app, with delegated permissions. |
| OAuth 2.0 Client credentials | A service account, with application permissions. |
| Client Certificate Authentication | A client certificate instead of a client secret, with application permissions. |
| Bring your own OAuth 2.0 app | A private app that you register in Azure, with delegated permissions. |
| OAuth 2.0 Authorization Code with PKCE | A private app that you register, without a client secret, with delegated permissions. |
Some methods need an administrator of your Microsoft tenant to grant consent first. PKCE stands for Proof Key for Code Exchange.
Microsoft OneDrive & SharePoint authentication in the Integration Service guide describes the full connection setup, including prerequisites and advanced settings.
Next steps
- Connector: every connector, grouped by area.
- Create a connection: sign a workflow in to an app.
- Community: ask questions and share workflows with other builders on the UiPath Forum.