Microsoft 365 Excel - Download Data from Workbook to Workflows
Overview
This blueprint can be used to download data from an Excel Sheet to Workflows. The `Sheet Name` must be specified, otherwise it will default to `Sheet1`. The downloaded file will be a CSV.
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 |
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 |
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 |
Sheet Name | EXCEL_SHEET_NAME | Alphanumeric | ➖ | Sheet1 | - | The name of the sheet containing the data |
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) |
YAML
Below is the YAML template
source:
template: Microsoft 365 Excel - Download Data from Workbook to Workflows
inputs:
EXCEL_CLIENT_ID:
EXCEL_CLIENT_SECRET:
EXCEL_TENANT:
EXCEL_USER_EMAIL:
EXCEL_ONEDRIVE_FOLDER:
EXCEL_ONEDRIVE_FILE_NAME:
EXCEL_SHEET_NAME: Sheet1
EXCEL_LOCAL_FOLDER_NAME:
EXCEL_SRC_FILE_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
- 249