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]

Operation ID:

PostItem

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]

Operation ID:

PostItem_V2

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]

Operation ID:

DeleteItem

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]

Operation ID:

GetItem

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]

Operation ID:

GetItem_V2

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]

Operation ID:

GetItems

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]

Operation ID:

GetItems_V2

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]

Operation ID:

PatchItem

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]

Operation ID:

PatchItem_V2

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]

Operation ID:

GetOnNewItems

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]

Operation ID:

GetOnNewItems_V2

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]

Operation ID:

GetOnUpdatedItems_V2

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]

Operation ID:

GetOnDeletedItems

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]

Operation ID:

GetOnUpdatedItems

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.