Query Records
query-recordsQuery PowerPlatform Dataverse entity records using OData filter expressions. Retrieve targeted data by filtering on specific conditions to access precise information across environments.
Instructions
Query records using an OData filter expression
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| entityNamePlural | Yes | The plural name of the entity (e.g., 'accounts', 'contacts') | |
| filter | Yes | OData filter expression (e.g., "name eq 'test'" or "createdon gt 2023-01-01") | |
| maxRecords | No | Maximum number of records to retrieve (default: 50) | |
| environment | No | Environment name (e.g. DEV, UAT). Uses default if omitted. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| entityNamePlural | Yes | ||
| filter | Yes | ||
| count | Yes | ||
| records | Yes |