UiPath Documentation
maestro-automate
latest
false
Maestro Automate ユーザー ガイド

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.

アクション​

Each action is a node that does one thing in Microsoft OneDrive & SharePoint.

操作機能
リスト アイテムを追加Add a new item to SharePoint List.
シートを追加Add a new sheet to the workbook.
秘密度ラベルを割り当てAssign a sensitivity label to a file in OneDrive.
ファイル/フォルダーをコピーCopy a file or folder to the specified destination folder in OneDrive or SharePoint.
フォルダーを作成Create a folder at the specified location in OneDrive or SharePoint.
ブックを作成Create a new workbook in OneDrive or SharePoint Document Library.
列を削除Delete a column from a worksheet in workbook.
ファイル/フォルダーを削除Delete a file or folder at the specific location in OneDrive or SharePoint.
リスト アイテムを削除Delete an item from a SharePoint List.
範囲を削除Delete data from specified range in workbook.
行を削除Delete data from specified rows in workbook.
シートを削除Delete a specified sheet from workbook.
ファイルをダウンロードDownload a file or folder from OneDrive & SharePoint.
ファイルをチェックイン/チェックアウトSharePoint ファイルをチェックインまたはチェックアウトします。
ファイルまたはフォルダーの存在を確認Check whether a file or folder exists in OneDrive or SharePoint.
ファイル/フォルダーを取得Get file or folder from OneDrive or SharePoint to use in other activities.
Get File or Folder by Sharing UrlResolve a OneDrive or SharePoint URL into a Reference ID and other identifiers that other activities accept as input.
ファイル/フォルダーのリストを取得Retrieve a list of files and folders from the specified OneDrive or SharePoint location.
ファイルまたはフォルダーのメタデータを取得Fetch metadata for a file from OneDrive & SharePoint.
リスト アイテムを取得Retrieve a list of items from a SharePoint List.
秘密度ラベルを取得Retrieve the sensitivity labels applied to a file.
単一のリスト アイテムを取得Retrieve a single item from a SharePoint List.
ファイル/フォルダーを移動Move a file or folder to the specified destination folder in OneDrive or SharePoint.
セルを読み込みRead the value of a cell in a worksheet.
範囲を読み込みRead data from a range of cells in a worksheet.
シート名を変更Rename an existing worksheet in a workbook.
ファイル/フォルダーを共有Share a file or folder.
ファイルまたはフォルダーのメタデータを更新Update metadata for a file or folder in OneDrive.
リストの項目を更新Update an item in a SharePoint List.
ファイルをアップロードUpload the specified file to OneDrive or SharePoint.
セルに書き込みWrite data into a specified cell of worksheet in workbook.
Write Column V2Write data into column in specified range of worksheet with advanced options.
範囲に書き込みWrite data into specified range in worksheet.
行を書き込み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.

イベント​

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.

イベント機能
ワークシート内のセルの更新時Starts the automation when a cell within a Worksheet is updated.
ファイルの作成時Triggers when a new file is created in the drive.
File Moved to TrashTriggers when an existing file is moved to trash from the drive.
ファイルの更新時Triggers when an existing file is updated in the drive.
Folder Moved to TrashTriggers when an existing folder is moved to trash in the drive.
リストアイテムの追加時When a new item is added to a SharePoint List.
リストアイテムの更新時When an item is modified in a SharePoint List.
テーブルの下部に追加された行When a row at the bottom of a table is filled in with appropriate columns as an optional data filter.
ワークシートの作成時Starts the automation when a new Sheet within a Spreadsheet is created.

コネクション​

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必要なもの
OAuth 2.0 の認可コードYour Microsoft account. It uses the UiPath public app, with delegated permissions.
OAuth 2.0 クライアント資格情報A service account, with application permissions.
クライアント証明書の認証A client certificate instead of a client secret, with application permissions.
独自の OAuth 2.0 アプリ (BYOA) を使用するA private app that you register in Azure, with delegated permissions.
PKCE を使用した OAuth 2.0 認可コード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.

次のステップ​

  • Connector: every connector, grouped by area.
  • Create a connection: sign a workflow in to an app.
  • コミュニティ: UiPath フォーラムで質問したり、他のビルダーとワークフローを共有したりできます。
  • アクション​
  • イベント​
  • コネクション​
  • 次のステップ​

このページは役に立ちましたか?

接続

ヘルプ リソース サポート(opens in new window)

学習する UiPath アカデミー(opens in new window)

質問する UiPath フォーラム(opens in new window)

最新情報を取得