Dynamics 365

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

Actions

Create a new record

This operation creates a new record of an entity

Required Parameters

Organization Name
string
Name of Dynamics 365 organization like Contoso
Entity Name
string
Name of the entity
Record Item
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)

Required Parameters

Organization Name
string
Name of Dynamics 365 organization like Contoso
Entity Name
string
Name of the 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

Organization Name
string
Name of Dynamics 365 organization like Contoso
Entity Name
string
Name of the 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

Organization Name
string
Name of Dynamics 365 organization like Contoso
Entity Name
string
Name of the 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 (with option sets exposed as strings)

Required Parameters

Organization Name
string
Name of Dynamics 365 organization like Contoso
Entity Name
string
Name of the 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

Organization Name
string
Name of Dynamics 365 organization like Contoso
Entity Name
string
Name of the 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.

List records

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

Required Parameters

Organization Name
string
Name of Dynamics 365 organization like Contoso
Entity Name
string
Name of the 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

Organization Name
string
Name of Dynamics 365 organization like Contoso
Entity Name
string
Name of the 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

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

Required Parameters

Organization Name
string
Name of Dynamics 365 organization like Contoso
Entity Name
string
Name of the 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

Organization Name
string
Name of Dynamics 365 organization like Contoso
Entity Name
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)

Required Parameters

Organization Name
string
Name of Dynamics 365 organization like Contoso
Entity Name
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)

Required Parameters

Organization Name
string
Name of Dynamics 365 organization like Contoso
Entity Name
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

Required Parameters

Organization Name
string
Name of Dynamics 365 organization like Contoso
Entity Name
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

Required Parameters

Organization Name
string
Name of Dynamics 365 organization like Contoso
Entity Name
string
Name of the entity

Returns

The outputs of this operation are dynamic.