Common Data Service

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 connection 1000 60 seconds

Creating a connection

To connect your account, you will need the following information:

Environment id
string
Environment id
Client ID
string
Client (or Application) ID of the Azure Active Directory application.
Client Secret
securestring
Client secret of the Azure Active Directory application.
Tenant
string
The tenant ID of for the Azure Active Directory application.
ResourceUri
string
The resource you are requesting authorization to use.
Grant Type
string
Grant type

Actions

Create a new record

This operation creates a new record of an entity

Required Parameters

Environment
string
Select an Environment
Entity Name
string
Select an Entity
Record Item
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

Required Parameters

Environment
string
Select an Environment
Entity Name
string
Select an Entity
Record Item
dynamic
Record to create

Returns

The outputs of this operation are dynamic.

Delete a record

This operation deletes a record from an entity collection

Required Parameters

Environment
string
Select an Environment
Entity Name
string
Select an Entity
Item identifier
string
Identifier for the record

Returns

The outputs of this operation are dynamic.

Get record

This operation retrieves the specified record for an entity

Required Parameters

Environment
string
Select an Environment
Entity Name
string
Select an Entity
Item identifier
string
Identifier for the record

Returns

The outputs of this operation are dynamic.

Gets an item from table [DEPRECATED]

Gets an item from table

Required Parameters

Environment
string
Select an Environment
Entity Name
string
Select an Entity
Item identifier
string
Identifier for the record

Returns

The outputs of this operation are dynamic.

List records

This operation gets records for an entity

Required Parameters

Environment
string
Select an Environment
Entity Name
string
Select an Entity

Optional Parameters

Aggregation transformation
string
A sequence of OData aggregation transformations
Filter Query
string
An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Order By
string
An ODATA orderBy query for specifying the order of entries.
Top Count
integer
Total number of entries to retrieve (default = all).
Expand Query
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

Required Parameters

Environment
string
Select an Environment
Entity Name
string
Select an Entity

Optional Parameters

Filter Query
string
An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Order By
string
An ODATA orderBy query for specifying the order of entries.
Top Count
integer
Total number of entries to retrieve (default = all).
Expand Query
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

Required Parameters

Environment
string
Select an Environment
Entity Name
string
Select an Entity
Record identifier
string
Identifier for the record
Record Item
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

Required Parameters

Environment
string
Select an Environment
Entity Name
string
Select an Entity
Record identifier
string
Identifier for the record
Record Item
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.

Required Parameters

Environment
string
Select an Environment.
Entity Name
string
Select an Entity.
Scope
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

Required Parameters

Environment
string
Select an Environment
Entity Name
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

Required Parameters

Environment
string
Select an Environment
Entity Name
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.

Required Parameters

Environment
string
Select an Environment.
Entity Name
string
Select an Entity.
Scope
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

Required Parameters

Environment
string
Select an Environment
Entity Name
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.

Required Parameters

Environment
string
Select an Environment.
Entity Name
string
Select an Entity.
Scope
string
Scope.

Optional Parameters

Attribute Filters
string

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

Required Parameters

Environment
string
Select an Environment
Entity Name
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

Required Parameters

Environment
string
Select an Environment
Entity Name
string
Select an Entity

Returns

The outputs of this operation are dynamic.