Connect Triggers to SharePoint Online

In order to automate tasks with time-based and event-based triggers in SharePoint online, triggers need to be configured and authorized to access your SharePoint online account.

The following list describes some examples of tasks that you can automate:

  • Create, read from, and write to a text file

  • Copy, move, rename, and delete a file

  • Check if a file exists and monitor changes

  • Create, copy, move, rename, and delete a folder

  • Check if a folder is empty and monitor folder changes

Prerequisites

  • Your SharePoint site address

  • Your Microsoft Office 365 account credentials

  • The one associated with your SharePoint account.

  • Access to Console + and Studio

Connect to SharePoint

SharePoint is a Microsoft Office browser-based app that you connect to through your web browser. It is used to help organizations collaborate with customers and colleagues and share documents.

To connect to SharePoint:

  1. Go to Office.com, and sign in to your account .

  2. Select the app launcher from the upper left side of the window.

    Depending on your theme, it may appear slightly different for you

  3. Click All apps.

  4. Click SharePoint.

    If you can't see it, you can use the search box.

Add a Trigger to SharePoint

To configure a trigger:

  1. Navigate to the desired location on your SharePoint account.

  2. Copy the URL of the page.

  3. Edit the URL to include only the folder path:

    https://qakryon.sharepoint.com/sites/qa/Shared Documents/Forms/AllItems.aspx?id=%2Fsites%2Fqa%2FShared Documents%2FTrigger Test%2FFiles

  4. Sign in to Console + (see Accessing Console Plus).

  5. Select Triggers from the Navigation menu.

  6. From the Trigger Properties page, click the Actions button and select Edit.

    Triggers can be edited only when they are inactive. If the trigger is currently active, you will be given the option to deactivate it in order to edit it.

  7. Under the File definitions - Folder location, select SharePoint Online and insert the copied URL.

  8. In most cases (depends on the SharePoint configuration) the trigger won't work without an Application ID.

    The Application ID should be provided by the SharePoint administrator.

    This can also be found in the Azure Admin Center.

  9. Click Save and activate.

Credentials Vault with Application ID

A General users and OAuth Authentication credential needs to be added to the Credentials Vault, to be used in the Triggers and advanced commands.

To add credentials for the trigger:

  1. Access the Credentials Vault in the Studio.

    For instructions, see: Accessing the Credentials Vault.

  2. In the Credentials Vault main window, select the General User tab.

  3. Add a General user credential.

    For instructions, see: Creating Credentials.

  4. Click Save.

  5. Select the Application Authentication tab.

  6. Add an OAuth Authentication credential and link it to the General user credential created in Step 3.