Excel

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.

Note:

  • This is a Standard connector.
  • Connector unavailable in LogicApps.

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.

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Creating a connection

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

Connection to file source
connection
Connection to file source

Actions

Delete row

Deletes a row from an Excel table

Required Parameters

File name
string
Excel file name
Table name
string
Excel table name
Row id
string
Unique identifier of the row to delete

Get row

Retrieves a single row from an Excel table

Required Parameters

File name
string
Excel file name
Table name
string
Excel table name
Row id
string
Unique identifier of row to retrieve

Returns

The outputs of this operation are dynamic.

Get rows

Retrieves rows from an Excel table

Required Parameters

File name
string
Excel file name
Table name
string
Excel table name

Optional Parameters

Top Count
integer
Total number of entries to retrieve (default = all).
Skip Count
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

Required Parameters

File name
string
Excel file name

Returns

Body
TablesList

Represents a list of tables.

Insert row

Inserts a new row into an Excel table

Required Parameters

File name
string
Excel file name
Table name
string
Excel table name
Row
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

Required Parameters

File name
string
Excel file name
Table name
string
Excel table name
Row id
string
Unique identifier of the row to update
Row
dynamic
Row with updated values

Returns

The outputs of this operation are dynamic.

Definitions

Table

Represents a table.

DisplayName
string
The display name of the table.
Name
string
The name of the table. The name is used at runtime.

TablesList

Represents a list of tables.

value
array of Table
List of Tables