Skip to main content
Skip table of contents

Microsoft 365 Excel - Upload Data to Workbook from Workflows

Overview

This blueprint is used to upload data from Workflows to a new or exisitng file. Once the data is loaded to the Excel workbook, it will reside in a single sheet called `Sheet1`. **Note**: Any existing files with the same name will be overwritten. The file type must be either a CSV or an XLSX. Additionally, this blueprint cannot be used to upload an excel sheet on your local machine.

Variables

NameReferenceTypeRequiredDefaultOptionsDescription
Client IDEXCEL_CLIENT_IDPassword--The Client ID of the app created in Azure
Client SecretEXCEL_CLIENT_SECRETPassword--The secret value of the app created in Azure
TenantEXCEL_TENANTPassword--The ID of the tenant associated with the app
User EmailEXCEL_USER_EMAILAlphanumeric--The email address of the user to impersonate
Workflows Folder NameEXCEL_LOCAL_FOLDER_NAMEAlphanumeric--
Workflows File NameEXCEL_SRC_FILE_NAMEAlphanumeric--The name of the file to load to Excel (must be either a csv or xlsx file)
OneDrive File NameEXCEL_ONEDRIVE_FILE_NAMEAlphanumeric--The name of the file once loaded to OneDrive. If omitted, the original file name will be used
OneDrive FolderEXCEL_ONEDRIVE_FOLDERAlphanumeric--The optional folder name of where to save the Excel workbook in OneDrive. If omitted, the file will be saved in the root

YAML

Below is the YAML template

YAML

source:
  template: Microsoft 365 Excel - Upload Data to Workbook from Workflows
  inputs:
    EXCEL_CLIENT_ID:
    EXCEL_CLIENT_SECRET:
    EXCEL_TENANT:
    EXCEL_USER_EMAIL:
    EXCEL_LOCAL_FOLDER_NAME:
    EXCEL_SRC_FILE_NAME:
    EXCEL_ONEDRIVE_FILE_NAME:
    EXCEL_ONEDRIVE_FOLDER:
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 180
    - 181
    - 182
    - 183
    - 184
    - 200
    - 202
    - 203
    - 249

      
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.