Common Data Service

Provides access to the environment database on the Microsoft Common Data Service.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure China regions
Flow Premium All Flow regions
PowerApps Premium All PowerApps regions

To use this connector in PowerApps, Learn more about how to use this connector in PowerApps..

PowerApps data type mappings

PowerApps Common Data Service (CDS) for Apps
Option Set Option Set, Two Option
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

PowerApps delegable functions and operations for the CDS for Apps

These PowerApps operations, for a given data type, may be delegated to the CDS for Apps for processing (rather than processing locally within PowerApps).

Item Number [1] Text [2] Option Set 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(entity, 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(EntityName, MyCol = Blank()).
  5. The aggregate functions are limited to a collection of 50,000 records. If needed, use the Filter function to select 50,000 records from a larger set before using the aggregate function.

Note

Option Sets, Guids, and Aggregate functions for CDS for Apps are supported only with the new version of the connector. Depending on the version of PowerApps that you're using, enable this connector with either the Preview switch titled:

  • Relational data, option sets, and other new features for CDS
    or this Experimental switch:
  • Use the Common Data Service experimental connector
    To find these switches, open the File menu, and then select App settings > Advanced settings.

Throttling Limits

Name Calls Renewal Period
API calls per connection100060 seconds

Actions

Create a new record

This operation creates a new record of an entity

Create a new record [DEPRECATED]

This operation creates a new record of an entity

Delete a record

This operation deletes a record from an entity collection

Get record

This operation retrieves the specified record for an entity

Gets an item from table [DEPRECATED]

Gets an item from table

List records

This operation gets records for an entity

List records [DEPRECATED]

This operation gets records for an entity

Update a record

This operation updates an existing record for an entity

Update a record [DEPRECATED]

This operation updates an existing record for an entity

Create a new record

This operation creates a new record of an entity

Parameters

Name Key Required Type Description
Environment
dataset True string

Select an Environment

Entity Name
table True string

Select an Entity

Record Item
item True dynamic

Record to create

Returns

The outputs of this operation are dynamic.

Create a new record [DEPRECATED]

This operation creates a new record of an entity

Parameters

Name Key Required Type Description
Environment
dataset True string

Select an Environment

Entity Name
table True string

Select an Entity

Record Item
item True dynamic

Record to create

Returns

The outputs of this operation are dynamic.

Delete a record

This operation deletes a record from an entity collection

Parameters

Name Key Required Type Description
Environment
dataset True string

Select an Environment

Entity Name
table True string

Select an Entity

Item identifier
id True string

Identifier for the record

Get record

This operation retrieves the specified record for an entity

Parameters

Name Key Required Type Description
Environment
dataset True string

Select an Environment

Entity Name
table True string

Select an Entity

Item identifier
id True string

Identifier for the record

Returns

The outputs of this operation are dynamic.

Gets an item from table [DEPRECATED]

Gets an item from table

Parameters

Name Key Required Type Description
Environment
dataset True string

Select an Environment

Entity Name
table True string

Select an Entity

Item identifier
id True string

Identifier for the record

Returns

The outputs of this operation are dynamic.

List records

This operation gets records for an entity

Parameters

Name Key Required Type Description
Environment
dataset True string

Select an Environment

Entity Name
table True string

Select an Entity

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 records [DEPRECATED]

This operation gets records for an entity

Parameters

Name Key Required Type Description
Environment
dataset True string

Select an Environment

Entity Name
table True string

Select an Entity

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 record

This operation updates an existing record for an entity

Parameters

Name Key Required Type Description
Environment
dataset True string

Select an Environment

Entity Name
table True string

Select an Entity

Record identifier
id True string

Identifier for the record

Record Item
item True dynamic

Record to update

Returns

The outputs of this operation are dynamic.

Update a record [DEPRECATED]

This operation updates an existing record for an entity

Parameters

Name Key Required Type Description
Environment
dataset True string

Select an Environment

Entity Name
table True string

Select an Entity

Record identifier
id True string

Identifier for the record

Record Item
item True dynamic

Record to update

Returns

The outputs of this operation are dynamic.

Triggers

When a record is created

Triggers a flow when an object is created in Dynamics 365.

When a record is created (Admin Only) [DEPRECATED]

Triggers a flow when an object is created in Dynamics 365

When a record is created (Admin Only) [DEPRECATED]

Triggers a flow when an object is created in Dynamics 365

When a record is deleted

Triggers a flow when an object is deleted in Dynamics 365.

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

Triggers a flow when an object is deleted in Dynamics 365

When a record is updated

Triggers a flow when an object is updated in Dynamics 365.

When a record is updated (Admin Only) [DEPRECATED]

Triggers a flow when an object is modified in Dynamics 365

When a record is updated (Admin Only) [DEPRECATED]

Triggers a flow when an object is modified in Dynamics 365

When a record is created

Triggers a flow when an object is created in Dynamics 365.

Parameters

Name Key Required Type Description
Environment
dataset True string

Select an Environment.

Entity Name
table True string

Select an Entity.

Scope
scope True string

Scope.

Returns

The outputs of this operation are dynamic.

When a record is created (Admin Only) [DEPRECATED]

Triggers a flow when an object is created in Dynamics 365

Parameters

Name Key Required Type Description
Environment
dataset True string

Select an Environment

Entity Name
table True string

Select an Entity

Returns

The outputs of this operation are dynamic.

When a record is created (Admin Only) [DEPRECATED]

Triggers a flow when an object is created in Dynamics 365

Parameters

Name Key Required Type Description
Environment
dataset True string

Select an Environment

Entity Name
table True string

Select an Entity

Returns

The outputs of this operation are dynamic.

When a record is deleted

Triggers a flow when an object is deleted in Dynamics 365.

Parameters

Name Key Required Type Description
Environment
dataset True string

Select an Environment.

Entity Name
table True string

Select an Entity.

Scope
scope True string

Scope.

Returns

The outputs of this operation are dynamic.

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

Triggers a flow when an object is deleted in Dynamics 365

Parameters

Name Key Required Type Description
Environment
dataset True string

Select an Environment

Entity Name
table True string

Select an Entity

Returns

The outputs of this operation are dynamic.

When a record is updated

Triggers a flow when an object is updated in Dynamics 365.

Parameters

Name Key Required Type Description
Environment
dataset True string

Select an Environment.

Entity Name
table True string

Select an Entity.

Scope
scope True string

Scope.

Attribute Filters
Attribute Filters string

Select an Environment.

Returns

The outputs of this operation are dynamic.

When a record is updated (Admin Only) [DEPRECATED]

Triggers a flow when an object is modified in Dynamics 365

Parameters

Name Key Required Type Description
Environment
dataset True string

Select an Environment

Entity Name
table True string

Select an Entity

Returns

The outputs of this operation are dynamic.

When a record is updated (Admin Only) [DEPRECATED]

Triggers a flow when an object is modified in Dynamics 365

Parameters

Name Key Required Type Description
Environment
dataset True string

Select an Environment

Entity Name
table True string

Select an Entity

Returns

The outputs of this operation are dynamic.