Read table rows
read_live_tableRead rows from a Dataverse table, SharePoint list, SQL table or Excel table. Read-only. Takes the same table, connector, dataset and connection as update_canvas_app addDataSource. Returns rows, columns and nextLink.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | Rows, 1 to 100. Default 20. | |
| skip | No | SQL and Excel: rows to skip, for the next page. | |
| table | Yes | Dataverse: the set name, e.g. accounts. SharePoint: the list title or id. SQL or Excel: the table. | |
| filter | No | An OData filter. | |
| select | No | Comma-separated columns. | |
| dataset | No | Where the table lives. SharePoint: the site URL. SQL: server,database. Excel: drive,file. | |
| connector | No | Omit for Dataverse. | |
| connection | No | The connection name, when you have more than one. | |
| continuationUrl | No | The nextLink from the previous reply, for the next page. | |
| environmentName | Yes | Name of the Power Platform environment. |