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

Name	Reference	Type	Required	Default	Options	Description
Client ID	EXCEL_CLIENT_ID	Password	✅	-	-	The Client ID of the app created in Azure
Client Secret	EXCEL_CLIENT_SECRET	Password	✅	-	-	The secret value of the app created in Azure
Tenant	EXCEL_TENANT	Password	✅	-	-	The ID of the tenant associated with the app
User Email	EXCEL_USER_EMAIL	Alphanumeric	✅	-	-	The email address of the user to impersonate
Workflows Folder Name	EXCEL_LOCAL_FOLDER_NAME	Alphanumeric	➖	-	-
Workflows File Name	EXCEL_SRC_FILE_NAME	Alphanumeric	✅	-	-	The name of the file to load to Excel (must be either a csv or xlsx file)
OneDrive File Name	EXCEL_ONEDRIVE_FILE_NAME	Alphanumeric	➖	-	-	The name of the file once loaded to OneDrive. If omitted, the original file name will be used
OneDrive Folder	EXCEL_ONEDRIVE_FOLDER	Alphanumeric	➖	-	-	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