Skip to main content
Skip table of contents

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

NameReferenceTypeRequiredDefaultOptionsDescription
Client IDEXCEL_CLIENT_IDPassword--The Client ID of the app created in Azure
Client SecretEXCEL_CLIENT_SECRETPassword--The secret value of the app created in Azure
TenantEXCEL_TENANTPassword--The ID of the tenant associated with the app
User EmailEXCEL_USER_EMAILAlphanumeric--The email address of the user to impersonate
OneDrive FolderEXCEL_ONEDRIVE_FOLDERAlphanumeric--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 NameEXCEL_ONEDRIVE_FILE_NAMEAlphanumeric--The name of the file once loaded to OneDrive. If omitted, the original file name will be used
Sheet NameEXCEL_SHEET_NAMEAlphanumericSheet1-The name of the sheet containing the data
Workflows Folder NameEXCEL_LOCAL_FOLDER_NAMEAlphanumeric--
Workflows File NameEXCEL_SRC_FILE_NAMEAlphanumeric--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

      
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.