All categories
System
Access management
AI
Appflows - Technical
Billing
Billing and policy
Built-in apps
Business cases addon
Business Intelligence
Business Operations and ERPs
Calendar addon
Commerce
Communication
Community apps
Contacts module
Contracts addon
CRM and Sales tools
Customer Support
Database
Education
Features
File and Document Management
Forms Addon (Legacy)
Getting started with Boost.space
HR management
Internet of Things
Invoices module
IT and Development
Lifestyle
Marketing
Marketplace - Overview
Marketplaces
Modules and Addons
News monitor addon (legacy)
Notes addon
Offers addon
Orders module
Other
Pages addon
Policy
Process Management
Productivity
Products module
Records
Spaces
Surveys and Forms
System Settings (for Admins)
Tasks module
Travel
Users and teams
Wall addon
Warehouses addon
Website Building
Work hours addon
Integrations
Apps
Connections
Errors
Functions
Getting started with Boost.space Integrator
Integrator Modules
Mapping
Scenarios
Tools
Tutorials
List of applications
Table of Contents
Active
This application does not need additional settings. So you can make connection only by using your login credentials or by following the instructions below .

Microsoft 365 Excel

[Important] Important

Any references to third-party products or services do not constitute Boost.space Product Documentation nor do they create any contractual obligations. This material is for informational purposes only and is subject to change without notice.

Boost.space does not warrant the availability, accuracy, reliability, completeness, or usefulness of any information regarding the subject of third-party services or systems.

The Microsoft 365 Excel modules enable you to monitor workbooks and rows or retrieve, add, update, or delete worksheets, rows, and tables in your Microsoft 365 Excel account.

To get started with Microsoft 365 Excel app, create an account at office.com.

Refer to the Microsoft Graph REST API documentation for the list of available endpoints.

Connect Microsoft 365 Excel to Boost.space Integrator

To connect to the Excel app:

  1. Log in to your Boost.space Integrator account, add any Microsoft 365 Excel module scenario, and click the Add button next to the Connection field.

    microsoft-excel-1.png

  2. Optional: In the Connection name field, enter a name in the connection.

  3. Click Save.

  4. If prompted, log in to your Microsoft account and confirm the access.

You have successfully connected the app and can now build scenarios.

Build Microsoft 365 Excel Scenarios

After connecting the app, you can perform the following actions:

Workbook

[Tip] Keyword Query Language

Use Keyword Query Language (KQL) search syntax to build your search queries in Microsoft modules. For more information, see Microsoft Graph help.

  • Watch Workbooks

  • Search Workbooks

  • Download a Workbook

Worksheet

  • Watch Worksheet Rows

  • List Worksheets

  • List Worksheet Rows

  • Add a Worksheet

  • Add a Worksheet Row

  • Update a Worksheet Row

  • Delete a Worksheet Row

Table

  • Watch Table Rows

  • List Tables

  • List Table Rows

  • Get a Table

  • Add a Table

    To use tables, see Add a Table

  • Add a Table Row

  • Add a Table Column

  • Update a Table

  • Update a Table Column

  • Delete a Table

Other

[Note] Note

When using these modules in the Microsoft 365 Excel integration, there is a maximum limit of 3300 records per request. This limit is set to prevent service interruptions and ensure optimal performance during data retrieval operations.

  • Retrieve Data

  • Make an API Call

Table

The tablehere refers to the embedded table element in the Workbook. Not the entire table (workbook/worksheet).

61d6a5c5dee7b.png

Add a Table

Adds a new table.

Required Permissions: Files.ReadWrite, Files.Read.All

Connection

Establish a connection to your Microsoft 365 account.

Update a Table

Select the option to choose the

Workbook ID

Enter the Workbook ID to whose worksheet you want to add a table.

Workbook

Select or map the workbook you want to use.

Worksheet

Select the Excel sheet you want to add a table to.

Has Headers

If you select this checkbox, the first defined row will be used as the table headers.

61d6a5c6eb16c.png

Address

Set the size of the table. For example, A1:C10 will create a table with 3 columns and 10 rows.

Permission information for Microsoft 365 Excel

  • Add a Table – Files.ReadWrite, Files.Read.All

  • Add a Table Row – Files.ReadWrite, Files.Read.All

  • Add a Worksheet – Files.ReadWrite, Files.Read.All

  • Add a Worksheet Row – Files.ReadWrite, Files.Read.All

  • Add/Update a Worksheet Row (Advanced) – Files.ReadWrite

  • Delete a Table – Files.ReadWrite, Files.Read.All

  • Delete a Worksheet Row – Files.ReadWrite, Files.Read.All

  • Download a Workbook – Files.ReadWrite, Files.Read.All

  • Get a Table – Files.ReadWrite, Files.Read.All

  • List Table Rows – Files.ReadWrite, Files.Read.All

  • List Tables – Files.ReadWrite, Files.Read.All

  • List Worksheet Rows – Files.ReadWrite, Files.Read.All

  • List Worksheets – Files.ReadWrite, Files.Read.All

  • Retrieve Data – Files.ReadWrite, Files.Read.All

  • Search Workbooks – Files.Read.All

  • Update a Table – Files.ReadWrite, Files.Read.All

  • Update a Worksheet Row – Files.ReadWrite, Files.Read.All

  • Watch Workbooks – Files.Read.All

  • Watch Worksheet Rows – Files.ReadWrite, Files.Read.All