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

YAML


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