Microsoft Dataverse (legacy)

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)

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)

This operation deletes a row from a table collection

Get row (legacy)

This operation retrieves the specified row for a table

Gets a row from table [DEPRECATED]

Gets a row from table

List rows (legacy)

This operation gets rows for a table

List rows [DEPRECATED]

This operation gets rows for a table

Update a row (legacy)

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)

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]

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)

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)

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]

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)

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]

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)

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]

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

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 (Admin Only) [DEPRECATED]

Triggers a flow when a row is added in Dataverse

When a row is deleted

Triggers a flow when a row is deleted in Dataverse.

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

Triggers a flow when a row is deleted in Dataverse

When a row is modified

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 (Admin Only) [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

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 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

The outputs of this operation are dynamic.

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

The outputs of this operation are dynamic.

When a row is deleted

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 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

The outputs of this operation are dynamic.

When a row is modified

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 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

The outputs of this operation are dynamic.

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

The outputs of this operation are dynamic.

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.