- Get started
- Build
- 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.
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.
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.