Dynamics 365

Microsoft Dynamics 365 is a cloud based service that provides a set of intelligent applications that seamlessly work together — unifying the capabilities of CRM business software and ERP systems.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure Government regions
     -   Azure China regions
Flow Standard All Flow regions except the following:
     -   US Government (GCC)
PowerApps Standard All PowerApps regions except the following:
     -   US Government (GCC)

To use this connector in PowerApps, learn more here.

PowerApps delegable functions and operations for Dynamics 365

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

Top-level functions

  Delegable
Average No
Filter Yes
LookUp Yes
Max No
Min No
Search Yes
Sort Yes
SortByColumns Yes
Sum No

Filter and LookUp predicates

  Delegable
Not Yes
IsBlank Yes
TrimEnds No
Len No
+, - No
<, <=, =, <>, >, >= Yes
And (&&), Or (||), Not (!) Yes
in No
StartsWith No

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

This operation creates a new record of an entity (with option sets exposed as strings)

Delete a record

This operation deletes a record from an entity collection

Get record

This operation retrieves the specified record for an entity

Get record

This operation retrieves the specified record for an entity (with option sets exposed as strings)

List records

This operation gets records for an entity

List records

This operation gets records for an entity (with option sets exposed as strings)

Update a record

This operation updates an existing record for an entity

Update a record

This operation updates an existing record for an entity (with option sets exposed as strings)

Create a new record

This operation creates a new record of an entity

Parameters

Name Key Required Type Description
Organization Name
dataset True string

Name of Dynamics 365 organization like Contoso

Entity Name
table True string

Name of the entity

Record Item
item True dynamic

Record to create

Returns

The outputs of this operation are dynamic.

Create a new record

This operation creates a new record of an entity (with option sets exposed as strings)

Parameters

Name Key Required Type Description
Organization Name
dataset True string

Name of Dynamics 365 organization like Contoso

Entity Name
table True string

Name of the 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
Organization Name
dataset True string

Name of Dynamics 365 organization like Contoso

Entity Name
table True string

Name of the 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
Organization Name
dataset True string

Name of Dynamics 365 organization like Contoso

Entity Name
table True string

Name of the entity

Item identifier
id True string

Identifier for the record

Returns

The outputs of this operation are dynamic.

Get record

This operation retrieves the specified record for an entity (with option sets exposed as strings)

Parameters

Name Key Required Type Description
Organization Name
dataset True string

Name of Dynamics 365 organization like Contoso

Entity Name
table True string

Name of the 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
Organization Name
dataset True string

Name of Dynamics 365 organization like Contoso

Entity Name
table True string

Name of the 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.

List records

This operation gets records for an entity (with option sets exposed as strings)

Parameters

Name Key Required Type Description
Organization Name
dataset True string

Name of Dynamics 365 organization like Contoso

Entity Name
table True string

Name of the 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
Organization Name
dataset True string

Name of Dynamics 365 organization like Contoso

Entity Name
table True string

Name of the 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

This operation updates an existing record for an entity (with option sets exposed as strings)

Parameters

Name Key Required Type Description
Organization Name
dataset True string

Name of Dynamics 365 organization like Contoso

Entity Name
table True string

Name of the 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

Triggers a flow when an object is created in Dynamics 365 (with option sets exposed as strings)

When a record is created or updated

Triggers a flow when an object is created or modified in Dynamics 365 (with option sets exposed as strings)

When a record is deleted

Triggers a flow when an object is deleted in Dynamics 365

When a record is updated

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
Organization Name
dataset True string

Name of Dynamics 365 organization like Contoso

Entity Name
table True string

Name of the entity

Returns

The outputs of this operation are dynamic.

When a record is created

Triggers a flow when an object is created in Dynamics 365 (with option sets exposed as strings)

Parameters

Name Key Required Type Description
Organization Name
dataset True string

Name of Dynamics 365 organization like Contoso

Entity Name
table True string

Name of the entity

Returns

The outputs of this operation are dynamic.

When a record is created or updated

Triggers a flow when an object is created or modified in Dynamics 365 (with option sets exposed as strings)

Parameters

Name Key Required Type Description
Organization Name
dataset True string

Name of Dynamics 365 organization like Contoso

Entity Name
table True string

Name of the 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
Organization Name
dataset True string

Name of Dynamics 365 organization like Contoso

Entity Name
table True string

Name of the entity

Returns

The outputs of this operation are dynamic.

When a record is updated

Triggers a flow when an object is modified in Dynamics 365

Parameters

Name Key Required Type Description
Organization Name
dataset True string

Name of Dynamics 365 organization like Contoso

Entity Name
table True string

Name of the entity

Returns

The outputs of this operation are dynamic.