Rows for first 500 columns are returned by default. The connector retrieves rows for 500 columns maximum in the List rows present in a table action.The connector supports files in Microsoft Excel Open XML Spreadsheet (*.xlsx) and Microsoft Excel Binary Workbook (.xlxb) formats.This can cause possible merge conflicts and data inconsistency. Users should avoid writing data to a single Excel file from multiple clients concurrently (Excel Desktop, Excel Web, Power Automate, LogicApps or PowerApps). Simultaneous file modifications made by other connectors or manual edits are not supported.An Excel file may be locked in OneDrive for an update or delete up to 12 minutes since the last use of the connector.In order to get all rows, please turn on pagination. The List rows present in a table action returns up to 256 rows by default.Only 1 filter function can be applied on a column.Supports the following filter functions: eq, ne, contains, startswith, endswith.The List rows present in a table action supports basic filtering and sorting:.

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 table action.

The maximum size of an Excel file that is supported by the Excel Online (OneDrive) connector is 5 MB.

This connector is available in the following products and regions: ServiceĪll Power Automate regions except the following:Īll Power Apps regions except the following:

This connection provider only supports personal (MSA) accounts. Excel Online (OneDrive) connection provider lets you work with Excel files stored in OneDrive.

Onedrive online