Excel [DEPRECATED]
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 |
|---|---|---|
| Power Automate | Standard | All Power Automate regions except the following: - China Cloud operated by 21Vianet |
| Power Apps | Standard | All Power Apps regions except the following: - China Cloud operated by 21Vianet |
| Contact | |
|---|---|
| Name | Microsoft |
| URL | Microsoft Power Automate Support Microsoft Power Apps Support |
| Connector Metadata | |
|---|---|
| Publisher | Microsoft |
| Website | https://products.office.com/excel |
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 Power Apps, learn more here.
This connector is deprecated in Power Automate, Logic Apps and Power Apps. 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:
- Maximum number of rows and columns on a worksheet - 1048576 rows and 16384 columns
General Limits
| Name | Value |
|---|---|
| Maximum file size (in bytes) | 2000000 |
| Maximum number of requests being processed by the connector concurrently (per Excel file) | 100 |
Creating a connection
The connector supports the following authentication types:
| Default | Parameters for creating connection. | All regions | Not shareable |
Default
Applicable: All regions
Parameters for creating connection.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
| Name | Type | Description | Required |
|---|---|---|---|
| Connection to file source | connection | Connection to file source | True |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| Delete row [DEPRECATED] |
Deletes a row from an Excel table |
| Get row [DEPRECATED] |
Retrieves a single row from an Excel table |
| Get rows [DEPRECATED] |
Retrieves rows from an Excel table |
| Get tables [DEPRECATED] |
Retrieves table names from an Excel file |
| Insert row [DEPRECATED] |
Inserts a new row into an Excel table |
| Update row [DEPRECATED] |
Updates an existing row in an Excel table |
Delete row [DEPRECATED]
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 [DEPRECATED]
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
Get rows [DEPRECATED]
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
Get tables [DEPRECATED]
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 [DEPRECATED]
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
Update row [DEPRECATED]
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
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 |