Excel

Microsoft Excel is a spreadsheet developed by Microsoft. Connect to your Microsoft Excel spreadsheets in your file services like OneDrive for Business, OneDrive, Dropbox, Box, etc. You can perform various actions such as create, update, get, and delete on rows in a table.

This connector is available in the following products and regions:

Service Class Regions
Flow Standard All Flow regions
PowerApps Standard All PowerApps regions

The Excel Connector currently connects to Tables only. It will insert a column called __PowerAppsId__ to the Table if there is no such column. This column is used to keep track of changes in the row.

To use this connector in PowerApps, learn more here.

This connector is deprecated in Flow. Please try using the new connectors to work with Excel files: Excel Online (Business) and Excel Online (OneDrive).

LIMITS

The following are some of the limits and restrictions:

  1. Maximum number of rows and columns on a worksheet - 1048576 rows and 16384 columns

Creating a connection

To connect your account, you will need the following information:

Name Type Description
Connection to file source connection

Connection to file source

Throttling Limits

Name Calls Renewal Period
API calls per connection10060 seconds

Actions

Delete row

Deletes a row from an Excel table

Get row

Retrieves a single row from an Excel table

Get rows

Retrieves rows from an Excel table

Get tables

Retrieves table names from an Excel file

Insert row

Inserts a new row into an Excel table

Update row

Updates an existing row in an Excel table

Delete row

Deletes a row from an Excel table

Parameters

Name Key Required Type Description
File name
dataset True string

Excel file name

Table name
table True string

Excel table name

Row id
id True string

Unique identifier of the row to delete

Get row

Retrieves a single row from an Excel table

Parameters

Name Key Required Type Description
File name
dataset True string

Excel file name

Table name
table True string

Excel table name

Row id
id True string

Unique identifier of row to retrieve

Returns

The outputs of this operation are dynamic.

Get rows

Retrieves rows from an Excel table

Parameters

Name Key Required Type Description
File name
dataset True string

Excel file name

Table name
table True string

Excel table name

Top Count
$top integer

Total number of entries to retrieve (default = all).

Skip Count
$skip integer

The number of entries to skip (default = 0).

Returns

The outputs of this operation are dynamic.

Get tables

Retrieves table names from an Excel file

Parameters

Name Key Required Type Description
File name
dataset True string

Excel file name

Returns

Represents a list of tables.

Body
TablesList

Insert row

Inserts a new row into an Excel table

Parameters

Name Key Required Type Description
File name
dataset True string

Excel file name

Table name
table True string

Excel table name

Row
item True dynamic

Row to insert into the specified Excel table

Returns

The outputs of this operation are dynamic.

Update row

Updates an existing row in an Excel table

Parameters

Name Key Required Type Description
File name
dataset True string

Excel file name

Table name
table True string

Excel table name

Row id
id True string

Unique identifier of the row to update

Row
item True dynamic

Row with updated values

Returns

The outputs of this operation are dynamic.

Definitions

Table

Represents a table.

Name Path Type Description
Name
Name string

The name of the table. The name is used at runtime.

DisplayName
DisplayName string

The display name of the table.

TablesList

Represents a list of tables.

Name Path Type Description
value
value array of Table

List of Tables