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