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

1. 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.
2. 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.
3. 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	-

1. Numeric with arithmetic expressions (for example, Filter(table, field + 10 > 100) ) aren't delegable. Language and TimeZone aren't delegable.
2. Doesn't support Trim[Ends] or Len. Does support other functions such as Left, Mid, Right, Upper, Lower, Replace, Substitute, etc.
3. DateTime is generally delegatable except for DateTime functions Now() and Today().
4. Supports comparisons. For example, Filter(TableName, MyCol = Blank()).
5. 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]

Operation ID:

PostItem_V2

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

The outputs of this operation are dynamic.

Add a new row [DEPRECATED]

Operation ID:

PostItem

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

The outputs of this operation are dynamic.

Delete a row (legacy) [DEPRECATED]

Operation ID:

DeleteItem

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]

Operation ID:

GetItem_V2

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

The outputs of this operation are dynamic.

Gets a row from table [DEPRECATED]

Operation ID:

GetItem

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

The outputs of this operation are dynamic.

List rows (legacy) [DEPRECATED]

Operation ID:

GetItems_V2

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

The outputs of this operation are dynamic.

List rows [DEPRECATED]

Operation ID:

GetItems

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

The outputs of this operation are dynamic.

Update a row (legacy) [DEPRECATED]

Operation ID:

PatchItem_V2

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

The outputs of this operation are dynamic.

Update a row [DEPRECATED]

Operation ID:

PatchItem

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

The outputs of this operation are dynamic.

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]

Operation ID:

GetOnNewItems

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

The outputs of this operation are dynamic.

When a row is added (Admin Only) [DEPRECATED]

Operation ID:

GetOnNewItems_V2

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

The outputs of this operation are dynamic.

When a row is added [DEPRECATED]

Operation ID:

SubscribeOnNewItems

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

The outputs of this operation are dynamic.

When a row is deleted (Admin Only) [DEPRECATED]

Operation ID:

GetOnDeletedItems

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

The outputs of this operation are dynamic.

When a row is deleted [DEPRECATED]

Operation ID:

SubscribeOnDeletedItems

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

The outputs of this operation are dynamic.

When a row is modified (Admin Only) [DEPRECATED]

Operation ID:

GetOnUpdatedItems_V2

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

The outputs of this operation are dynamic.

When a row is modified (Admin Only) [DEPRECATED]

Operation ID:

GetOnUpdatedItems

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

The outputs of this operation are dynamic.

When a row is modified [DEPRECATED]

Operation ID:

SubscribeOnUpdatedItems

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

The outputs of this operation are dynamic.

When a row is selected

Operation ID:

OnItemSelected

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.