Dynamics 365 (deprecated) [DEPRECATED]

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
     -   US Department of Defense (DoD)
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Contact
Name Microsoft
URL Microsoft LogicApps Support
Microsoft Power Automate Support
Microsoft Power Apps Support
Connector Metadata
Publisher Microsoft
Website https://dynamics.microsoft.com/

This connector is deprecated. Please see the announcement here.

To use this connector in Power Apps, learn more here.

Power Apps delegable functions and operations for Dynamics 365

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

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

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

Create a new record (deprecated) [DEPRECATED]

This operation creates a new record of an entity

Create a new record (deprecated) [DEPRECATED]

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

Delete a record (deprecated) [DEPRECATED]

This operation deletes a record from an entity collection

Get record (deprecated) [DEPRECATED]

This operation retrieves the specified record for an entity

Get record (deprecated) [DEPRECATED]

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

List records (deprecated) [DEPRECATED]

This operation gets records for an entity

List records (deprecated) [DEPRECATED]

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

Update a record (deprecated) [DEPRECATED]

This operation updates an existing record for an entity

Update a record (deprecated) [DEPRECATED]

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

Create a new record (deprecated) [DEPRECATED]

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 (deprecated) [DEPRECATED]

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 (deprecated) [DEPRECATED]

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 (deprecated) [DEPRECATED]

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 (deprecated) [DEPRECATED]

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 (deprecated) [DEPRECATED]

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 (deprecated) [DEPRECATED]

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 (deprecated) [DEPRECATED]

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 (deprecated) [DEPRECATED]

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 (deprecated) [DEPRECATED]

Triggers a flow when an object is created in Dynamics 365

When a record is created (deprecated) [DEPRECATED]

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

When a record is created or updated (deprecated) [DEPRECATED]

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

When a record is deleted (deprecated) [DEPRECATED]

Triggers a flow when an object is deleted in Dynamics 365

When a record is updated (deprecated) [DEPRECATED]

Triggers a flow when an object is modified in Dynamics 365

When a record is created (deprecated) [DEPRECATED]

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 (deprecated) [DEPRECATED]

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 (deprecated) [DEPRECATED]

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 (deprecated) [DEPRECATED]

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 (deprecated) [DEPRECATED]

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.