다음을 통해 공유

Microsoft Dataverse [DEPRECATED]

  • Reference

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.