Microsoft Dataverse [DEPRECATED]
Provides access to the environment database in Microsoft Dataverse.
This connector is available in the following products and regions:
| Service | Class | Regions |
|---|---|---|
| Logic Apps | Standard | All Logic Apps regions |
| Power Automate | Premium | All Power Automate regions |
| Power Apps | - | Not available |
| Contact | |
|---|---|
| Name | Microsoft |
| URL | Microsoft LogicApps Support Microsoft Power Automate Support |
| Connector Metadata | |
|---|---|
| Publisher | Microsoft |
| Website | https://powerapps.microsoft.com/common-data-service/ |
Note
Microsoft Dataverse (legacy) connector will be supported by Microsoft until the Microsoft Dataverse connector supports Logic Apps.
To use this connector in Power Apps, Learn more about how to use this connector in Power Apps..
Known issues and limitations
- There are occurrences when CDS triggers do not work in Production environment with Administrative Mode set to "on". If you experience this issue, a workaround would be to turn off the Admin Mode in the Power Platforms Admin Center.
- If the administration mode is enabled for used Environment (either a sandbox or production), the Power Automate flow with When a record is modified trigger will not fire when a record is modified. For more details on how to set administration mode, please refer to this page.
- When you use the "When a record is selected" trigger in a flow and have an If Condition step right after, you will receive an error if the attribute in the condition has a null value. The error message you will see is "'Invalid type. Expected String but got Null.". The suggested workaround is to insert a "Get Row" action between the "When the record is selected" and the If Condition step. By using the output of the "Get Row" action in your condition, you will be able to avoid this error.
Power Apps data type mappings
| Power Apps | Microsoft Dataverse (legacy) |
|---|---|
| Choice | Choice, Yes/No |
| DateTime | Date Time, Date and Time, Date Only |
| Image | Image |
| Number | Floating Point Number, Currency, Decimal Number, Duration, Language, TimeZone, Whole Number |
| Text | Email, Multiline Text, Phone, Text, Text Area, Ticker Symbol, URL |
| Guid | Unique Identifier |
Power Apps delegable functions and operations for Dataverse
These Power Apps operations, for a given data type, may be delegated to Dataverse for processing (rather than processing locally within Power Apps).
| Item | Number [1] | Text [2] | Choice | DateTime [3] | Guid |
|---|---|---|---|---|---|
| Filter | Yes | Yes | Yes | Yes | Yes |
| Sort | Yes | Yes | No | Yes | - |
| SortByColumns | Yes | Yes | No | Yes | - |
| Lookup | Yes | Yes | Yes | Yes | Yes |
| =, <> | Yes | Yes | Yes | Yes | Yes |
| <, <=, >, >= | Yes | Yes | No | Yes | - |
| And/Or/Not | Yes | Yes | Yes | Yes | Yes |
| StartsWith | - | Yes | - | - | - |
| IsBlank | Yes [4] | Yes [4] | No [4] | Yes [4] | Yes |
| Sum, Min, Max, Avg | Yes [5] | - | - | No | - |
- Numeric with arithmetic expressions (for example, Filter(table, field + 10 > 100) ) aren't delegable. Language and TimeZone aren't delegable.
- Doesn't support Trim[Ends] or Len. Does support other functions such as Left, Mid, Right, Upper, Lower, Replace, Substitute, etc.
- DateTime is generally delegatable except for DateTime functions Now() and Today().
- Supports comparisons. For example, Filter(TableName, MyCol = Blank()).
- The aggregate functions are limited to a collection of 50,000 rows. If needed, use the Filter function to select 50,000 rows from a larger set before using the aggregate function.
Note
Choices, Guids, and Aggregate functions for Dataverse are supported only with the new version of the connector. Depending on the version of Power Apps that you're using, enable this connector with either the Preview switch titled:
- Relational data, choices, and other new features for Dataverse
or this Experimental switch: - Use the Dataverse connector
To find these switches, open the File menu, and then select App settings > Advanced settings.
Connector in-depth
For more information about the connector, see the in-depth section.
Creating a connection
The connector supports the following authentication types:
| Default | Parameters for creating connection. | All regions | Not shareable |
Default
Applicable: All regions
Parameters for creating connection.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 1000 | 60 seconds |
Actions
| Add a new row (legacy) [DEPRECATED] |
This operation adds a new row of a table |
| Add a new row [DEPRECATED] |
This operation adds a new row of a table |
| Delete a row (legacy) [DEPRECATED] |
This operation deletes a row from a table collection |
| Get row (legacy) [DEPRECATED] |
This operation retrieves the specified row for a table |
| Gets a row from table [DEPRECATED] |
Gets a row from table |
| List rows (legacy) [DEPRECATED] |
This operation gets rows for a table |
| List rows [DEPRECATED] |
This operation gets rows for a table |
| Update a row (legacy) [DEPRECATED] |
This operation updates an existing row for a table |
| Update a row [DEPRECATED] |
This operation updates an existing row for a table |
Add a new row (legacy) [DEPRECATED]
This operation adds a new row of a table
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Environment
|
dataset | True | string |
Select an Environment |
|
Table Name
|
table | True | string |
Select a table |
|
Row Item
|
item | True | dynamic |
Row to create |
Returns
Add a new row [DEPRECATED]
This operation adds a new row of a table
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Environment
|
dataset | True | string |
Select an Environment |
|
Table Name
|
table | True | string |
Select a table |
|
Row Item
|
item | True | dynamic |
Row to create |
Returns
Delete a row (legacy) [DEPRECATED]
This operation deletes a row from a table collection
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Environment
|
dataset | True | string |
Select an Environment |
|
Table Name
|
table | True | string |
Select a table |
|
Item identifier
|
id | True | string |
Identifier for the row |
Get row (legacy) [DEPRECATED]
This operation retrieves the specified row for a table
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Environment
|
dataset | True | string |
Select an Environment |
|
Table Name
|
table | True | string |
Select a table |
|
Item identifier
|
id | True | string |
Identifier for the row |
Returns
Gets a row from table [DEPRECATED]
Gets a row from table
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Environment
|
dataset | True | string |
Select an Environment |
|
Table Name
|
table | True | string |
Select a table |
|
Item identifier
|
id | True | string |
Identifier for the row |
Returns
List rows (legacy) [DEPRECATED]
This operation gets rows for a table
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Environment
|
dataset | True | string |
Select an Environment |
|
Table Name
|
table | True | string |
Select a table |
|
Aggregation transformation
|
$apply | string |
A sequence of OData aggregation transformations |
|
|
Filter Query
|
$filter | string |
An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123). |
|
|
Order By
|
$orderby | string |
An ODATA orderBy query for specifying the order of entries. |
|
|
Top Count
|
$top | integer |
Total number of entries to retrieve (default = all). |
|
|
Expand Query
|
$expand | string |
Related entries to include with requested entries (default = none) |
Returns
List rows [DEPRECATED]
This operation gets rows for a table
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Environment
|
dataset | True | string |
Select an Environment |
|
Table Name
|
table | True | string |
Select a table |
|
Filter Query
|
$filter | string |
An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123). |
|
|
Order By
|
$orderby | string |
An ODATA orderBy query for specifying the order of entries. |
|
|
Top Count
|
$top | integer |
Total number of entries to retrieve (default = all). |
|
|
Expand Query
|
$expand | string |
Related entries to include with requested entries (default = none) |
Returns
Update a row (legacy) [DEPRECATED]
This operation updates an existing row for a table
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Environment
|
dataset | True | string |
Select an Environment |
|
Table Name
|
table | True | string |
Select a table |
|
Row identifier
|
id | True | string |
Identifier for the row |
|
Row Item
|
item | True | dynamic |
Row to update |
Returns
Update a row [DEPRECATED]
This operation updates an existing row for a table
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Environment
|
dataset | True | string |
Select an Environment |
|
Table Name
|
table | True | string |
Select a table |
|
Row identifier
|
id | True | string |
Identifier for the row |
|
Row Item
|
item | True | dynamic |
Row to update |
Returns
Triggers
| When a row is added (Admin Only) [DEPRECATED] |
Triggers a flow when a row is added in Dataverse |
| When a row is added (Admin Only) [DEPRECATED] |
Triggers a flow when a row is added in Dataverse |
| When a row is added [DEPRECATED] |
Triggers a flow when a row is added in Dataverse. |
| When a row is deleted (Admin Only) [DEPRECATED] |
Triggers a flow when a row is deleted in Dataverse |
| When a row is deleted [DEPRECATED] |
Triggers a flow when a row is deleted in Dataverse. |
| When a row is modified (Admin Only) [DEPRECATED] |
Triggers a flow when a row is modified in Dataverse |
| When a row is modified (Admin Only) [DEPRECATED] |
Triggers a flow when a row is modified in Dataverse |
| When a row is modified [DEPRECATED] |
Triggers a flow when a row is modified in Dataverse. |
| When a row is selected |
Trigger a flow when a row is selected from the Flow menu in the command bar. (Available only for Power Automate.) |
When a row is added (Admin Only) [DEPRECATED]
Triggers a flow when a row is added in Dataverse
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Environment
|
dataset | True | string |
Select an Environment |
|
Table Name
|
table | True | string |
Select a table |
Returns
When a row is added (Admin Only) [DEPRECATED]
Triggers a flow when a row is added in Dataverse
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Environment
|
dataset | True | string |
Select an Environment |
|
Table Name
|
table | True | string |
Select a table |
Returns
When a row is added [DEPRECATED]
Triggers a flow when a row is added in Dataverse.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Environment
|
dataset | True | string |
Select an Environment. |
|
Table Name
|
table | True | string |
Select a table. |
|
Scope
|
scope | True | string |
Scope. |
Returns
When a row is deleted (Admin Only) [DEPRECATED]
Triggers a flow when a row is deleted in Dataverse
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Environment
|
dataset | True | string |
Select an Environment |
|
Table Name
|
table | True | string |
Select a table |
Returns
When a row is deleted [DEPRECATED]
Triggers a flow when a row is deleted in Dataverse.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Environment
|
dataset | True | string |
Select an Environment. |
|
Table Name
|
table | True | string |
Select a table. |
|
Scope
|
scope | True | string |
Scope. |
Returns
When a row is modified (Admin Only) [DEPRECATED]
Triggers a flow when a row is modified in Dataverse
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Environment
|
dataset | True | string |
Select an Environment |
|
Table Name
|
table | True | string |
Select a table |
Returns
When a row is modified (Admin Only) [DEPRECATED]
Triggers a flow when a row is modified in Dataverse
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Environment
|
dataset | True | string |
Select an Environment |
|
Table Name
|
table | True | string |
Select a table |
Returns
When a row is modified [DEPRECATED]
Triggers a flow when a row is modified in Dataverse.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Environment
|
dataset | True | string |
Select an Environment. |
|
Table Name
|
table | True | string |
Select a table. |
|
Scope
|
scope | True | string |
Scope. |
|
Column Filters
|
AttributeFilters | array of string |
Column filters |
Returns
When a row is selected
Trigger a flow when a row is selected from the Flow menu in the command bar. (Available only for Power Automate.)
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
operationId
|
operationId | True | string | |
|
host
|
host | object | ||
|
parameters
|
parameters | True | object | |
|
schema
|
schema | True | object | |
|
headersSchema
|
headersSchema | object |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
rows
|
body.rows | array of object | |
|
items
|
body.rows | object | |
|
User id
|
headers.x-ms-user-id-encoded | guid |
The unique identifier of the user who triggered the flow in AAD. |
|
User email
|
headers.x-ms-user-email-encoded | byte |
The email address of the user who triggered the flow. |
|
User name
|
headers.x-ms-user-name-encoded | byte |
The display name of the user who triggered the flow. |
|
Timestamp
|
headers.x-ms-user-timestamp | string |
The time the flow was triggered. |