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
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