Make sure everyone who's working in Excel for Microsoft 365 or Excel for Microsoft 365 for Mac has AutoSave on in the upper-left corner of the Excel window. If you're using OneDrive to sync files, make sure it's not paused, and make sure that Use Office 2016 to sync files. Microsoft Excel 2013 is a program that allows you to discover and reveal the insights hidden in your documents data. You can access, edit and view documents, perform complex analyses quickly, summarize your data with previews of various pivot-table options, so you can compare them.
- Onedrive Excel Read Only
- Onedrive Excel Tutorial
- Onedrive Excel Version History
- Onedrive Excel Read Only
- Onedrive Excel Login
- Onedrive Excel Upload Blocked
Excel Online (OneDrive) connection provider lets you work with Excel files stored in OneDrive. This connection provider only supports personal (MSA) accounts.
This connector is available in the following products and regions:
| Service | Class | Regions |
|---|---|---|
| Logic Apps | Standard | All Logic Apps regions |
| Power Automate | Standard | All Power Automate regions except the following: - US Government (GCC High) - China Cloud operated by 21Vianet |
| Power Apps | - | Not available |
| Connector Metadata | |
|---|---|
| Publisher | Microsoft |
Known Issues and Limitations
- The maximum size of an Excel file that is supported by the Excel Online (OneDrive) connector is 5 MB.
- The data may not be up to date (there may be some delay) when filtering or sorting is used in the
List rows present in a tableaction. - The
List rows present in a tableaction supports basic filtering and sorting:- Supports the following filter functions: eq, ne, contains, startswith, endswith.
- Only 1 filter function can be applied on a column.
- Only 1 column can be used for sorting.
- An Excel file may be locked in OneDrive for an update or delete up to 12 minutes since the last use of the connector.
- A single Excel file should be used by a single connection to prevent writing data from multiple connections and possible data inconsistency.
- Simultaneous file modifications made by other connectors or manual edits are not supported.
- The connector supports files only in Microsoft Excel Open XML Spreadsheet format (*.xlsx).
- The connector retrieves rows for 500 columns maximum in the
List rows present in a tableaction. Rows for first 500 columns are returned by default. You can provide comma-separated list of specific columns to retrieve inSelect Queryparameter. - The connector doesn't support using OData parameters for tables that contain hidden columns.
- The connector timeout caused by re-calculations can occur, either there are complicated formulas or there are too many rows in the worksheet. In both cases, data can be inserted multiple times because of retry policy.
- The connector will return the Bad Gateway error if the spreadsheet is in a read-only mode. In order to disable read-only mode, please learn more here.
Filter Query/Order By/Select Queryoperation parameters support only alphanumeric column names.- Pivot tables are not supported due to Graph API limitations.
- If a user makes too many requests within a short period of time, it is possible to get a 429 response. The throttling limit is unique to each request and it varies based on the request count, memory used, and other important factors.
- In operations such as
Delete a row, thekey columnfield iscase-sensitive. - In case of multiple matches in operations such as
Update a row,Delete a rowoperations, only the first row will be updated/deleted.
Column names handling
Please note that column names in the action's response results may be transformed in order to be compatible with OData format:
| Character | Encoded value |
|---|---|
| . | _x002e_ |
| @ | _x0040_ |
| : | _x003a_ |
| # | _x0023_ |
E.g. Column [one]#1 -> Column [one]_x0023_1
Concepts and examples
Key column: column in a table that will be use to search a value (key value)Key value: value in thekey columnthat will be used to identify a specific row.
Take the following table as an example. To perform a row operation in the second row of the table, the key column should be Column 1 and key value should be 200.
| Column 1 | Column 2 | Column 3 |
|---|---|---|
| 100 | A-2 | A-3 |
| 200 | B-2 | B-3 |
| 300 | C-2 | C-3 |
General Limits
| Name | Value |
|---|---|
| Maximum number of identity column variants that can be used to Get/Insert/Update/Delete a row from a single excel table. Current value is set to 2, which means that up to two column name variants should be in use across workflows for one particular table. | 2 |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| Add a key column to a table | Add a key column to an Excel table. The new column will be appended to the right. The new key column must be unique in the table. |
| Add a row into a table | Add a new row into the Excel table. |
| Add a row into a table [DEPRECATED] | This action has been deprecated. Please use Add a row into a table instead.
|
| Create table | Create a new table in the Excel workbook. |
| Create worksheet | Create a new worksheet in the Excel workbook. |
| Delete a row | Delete a row using a key column. |
| Get a row | Get a row using a key column. This action will retrieve all the values of the specified row given a column and key column. |
| Get tables | Get a list of tables in the Excel workbook. |
| Get worksheets | Get a list of worksheets in the Excel workbook. |
| List rows present in a table | List rows present in a table. |
| Update a row | Update a row using a key column. The input value will overwrite the specified cells and columns left blank will not be updated. In order to append (instead of overwrite) a value, use the 'Get a row' action to retrieve the content first. |
Add a key column to a table
Add a key column to an Excel table. The new column will be appended to the right. The new key column must be unique in the table.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
| file | True | string | Select an Excel file through File Browse. | |
Table | table | True | string | Select a table from the drop-down. |
| idColumn | string | Provide the key column name. |
Add a row into a table
Add a new row into the Excel table.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
| file | True | string | Select an Excel file through File Browse. | |
Table | table | True | string | Select a table from the drop-down. |
| item | True | dynamic | Row to add into the specified Excel table. | |
DateTime Format | dateTimeFormat | string | DateTime Format. |
Returns
Add a row into a table [DEPRECATED]
This action has been deprecated. Please use Add a row into a table instead.
Add a new row into the Excel table.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
| file | True | string | Select an Excel file through File Browse. | |
Table | table | True | string | Select a table from the drop-down. |
| item | True | dynamic | Row to insert into the specified Excel table. |
Returns
Create table
Create a new table in the Excel workbook.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
| file | True | string | Select an Excel file through File Browse. | |
Table name | TableName | string | Enter the Excel table name. | |
| Range | True | string | Enter the table address using A1 notation. | |
Columns names | ColumnsNames | string | Enter the columns names separated by ';' or ','. |
Returns
Table metadata
Create worksheet
Create a new worksheet in the Excel workbook.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
| file | True | string | Select an Excel file through File Browse. | |
Name | name | string | Worksheet name. |
Returns
Delete a row
Delete a row using a key column.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
| file | True | string | Select an Excel file through File Browse. | |
Table | table | True | string | Select a table from the drop-down. |
| idColumn | True | string | Select a column from the drop-down. | |
Key Value | id | True | string | Enter the key value. |
Get a row
Get a row using a key column. This action will retrieve all the values of the specified row given a column and key column.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
| file | True | string | Select an Excel file through File Browse. | |
Table | table | True | string | Select a table from the drop-down. |
| idColumn | True | string | Select a column from the drop-down. | |
Key Value | id | True | string | Enter the key value. |
| dateTimeFormat | string | DateTime Format. |
Returns
Get tables
Get a list of tables in the Excel workbook.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
| file | True | string | 44re transmission rebuild kit. Select an Excel file through File Browse. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
value | value | array of object | |
| value.id | string | Table Id. | |
Name | value.name | string | Table name. |
| value.showBandedColumns | boolean | Show banded columns. | |
Highlight first column | value.highlightFirstColumn | boolean | Highlight first column. |
| value.highlightLastColumn | boolean | Highlight last column. | |
Show banded rows | value.showBandedRows | boolean | Show banded rows. |
| value.showFilterButton | boolean | Show filter button. | |
Show headers | value.showHeaders | boolean | Show headers. |
| value.showTotals | boolean | Show totals. | |
Style | value.style | string | Table style. |
Get worksheets
Get a list of worksheets in the Excel workbook.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
| file | True | string | Select an Excel file through File Browse. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
value | value | array of WorksheetMetadata |
List rows present in a table
List rows present in a table.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
| file | True | string | Select an Excel file through File Browse. | |
Table | table | True | string | Select a table from the drop-down. |
| $filter | string | An ODATA filter query to restrict the entries returned. | ||
Order By | $orderby | string | An ODATA orderBy query for specifying the order of entries. | |
| $top | integer | Total number of entries to retrieve (default = all). | ||
Skip Count | $skip | integer | The number of entries to skip (default = 0). | |
| $select | string | Comma-separated list of columns to retrieve (first 500 by default). | ||
DateTime Format | dateTimeFormat | string | DateTime Format. |
Returns
Onedrive Excel Read Only
Update a row
Update a row using a key column. The input value will overwrite the specified cells and columns left blank will not be updated. In order to append (instead of overwrite) a value, use the 'Get a row' action to retrieve the content first.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
| file | True | string | Select an Excel file through File Browse. | |
Table | table | True | string | Select a table from the drop-down. |
| idColumn | True | string | Select a column from the drop-down. | |
Key Value | id | True | string | Enter the key value. |
| item | True | dynamic | Provide the item properties. | |
DateTime Format | dateTimeFormat | string | DateTime Format. |
Returns
Onedrive Excel Tutorial
Definitions
TableMetadata
Table metadata
| Name | Path | Type | Description |
|---|---|---|---|
| name | string | Table name | |
title | title | string | Table title |
| x-ms-permission | string | Table permission | |
x-ms-capabilities | x-ms-capabilities | TableCapabilitiesMetadata | Metadata for a table (capabilities) |
| schema | Object | ||
referencedEntities | referencedEntities | Object | |
| webUrl | string | Url link |
TableCapabilitiesMetadata
Metadata for a table (capabilities)
| Name | Path | Type | Description |
|---|---|---|---|
| sortRestrictions | TableSortRestrictionsMetadata | Metadata for a table (sort restrictions) | |
filterRestrictions | filterRestrictions | TableFilterRestrictionsMetadata | Metadata for a table (filter restrictions) |
| selectRestrictions | TableSelectRestrictionsMetadata | Metadata for a table (select restrictions) | |
isOnlyServerPagable | isOnlyServerPagable | boolean | Server paging restrictions |
| filterFunctionSupport | array of string | List of supported filter capabilities | |
serverPagingOptions | serverPagingOptions | array of string | List of supported server-driven paging capabilities |
Object
TableSortRestrictionsMetadata
Metadata for a table (sort restrictions)
| Name | Path | Type | Description |
|---|---|---|---|
| sortable | boolean | Indicates whether this table has sortable columns | |
unsortableProperties | unsortableProperties | array of string | List of unsortable properties |
| ascendingOnlyProperties | array of string | List of properties which support ascending order only |
TableFilterRestrictionsMetadata
Onedrive Excel Version History
Metadata for a table (filter restrictions)
Onedrive Excel Read Only
| Name | Path | Type | Description |
|---|---|---|---|
| filterable | boolean | Indicates whether this table has filterable columns | |
nonFilterableProperties | nonFilterableProperties | array of string | List of non filterable properties |
| requiredProperties | array of string | List of required properties |
TableSelectRestrictionsMetadata
Metadata for a table (select restrictions)
Onedrive Excel Login
| Name | Path | Type | Description |
|---|---|---|---|
| selectable | boolean | Indicates whether this table has selectable columns |
WorksheetMetadata
Onedrive Excel Upload Blocked
| Name | Path | Type | Description |
|---|---|---|---|
| id | string | Worksheet Id. | |
Name | name | string | Worksheet name. |
| position | integer | Worksheet position. | |
Visibility | visibility | string | Worksheet visibility. |