Breadcrumbs

Microsoft 365 SharePoint - Upload Files from Workflows to SharePoint

Overview

This blueprint can be used to upload one or multiple files to SharePoint from Workflows.

Note: Any existing files with the same name will be overwritten.

The match type selected greatly affects how this Blueprint works.

Variables

Name

Reference

Type

Required

Default

Options

Description

Client ID

SHAREPOINT_CLIENT_ID

Password

-

-

The Client ID of the app created in Azure

Client Secret

SHAREPOINT_CLIENT_SECRET

Password

-

-

The secret value of the app created in Azure

Tenant

SHAREPOINT_TENANT

Alphanumeric

-

-

The ID of the tenant associated with the app

Site Name

SHAREPOINT_SITE_NAME

Alphanumeric

-

-

The name of the SharePoint Site

Workflows File Match Type

SHAREPOINT_FILE_MATCH_TYPE

Select

exact_match

Exact Match: exact_match

Regex Match: regex_match

The match type used to identify files to load

Workflows Folder Name

SHAREPOINT_LOCAL_FOLDER_NAME

Alphanumeric

-

-

The optional name of the folder where the data to load resides

Workflows File Name

SHAREPOINT_LOCAL_FILE_NAME

Alphanumeric

-

-

The name of the file(s) to load to OneDrive

SharePoint File Name

SHAREPOINT_FILE_NAME

Alphanumeric

-

-

The name of the file once it is loaded to SharePoint. If omitted, the original file name will be used

SharePoint Folder Name

SHAREPOINT_FOLDER_NAME

Alphanumeric

-

-

The optional folder to load the file(s) to. If omitted, the files will be loaded to the root directory

YAML

Below is the YAML template

YAML

source:
  template: Microsoft 365 SharePoint - Upload Files from Workflows to SharePoint
  inputs:
    SHAREPOINT_CLIENT_ID:
    SHAREPOINT_CLIENT_SECRET:
    SHAREPOINT_TENANT:
    SHAREPOINT_SITE_NAME:
    SHAREPOINT_FILE_MATCH_TYPE: exact_match
    SHAREPOINT_LOCAL_FOLDER_NAME:
    SHAREPOINT_LOCAL_FILE_NAME:
    SHAREPOINT_FILE_NAME:
    SHAREPOINT_FOLDER_NAME:
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 180
    - 181
    - 182
    - 183
    - 184
    - 200
    - 202
    - 203
    - 204
    - 205
    - 206
    - 207
    - 208
    - 209
    - 210
    - 249