Fin & Ops Apps (Dynamics 365)

Fin & Ops Apps (Dynamics 365) connector provides access to data entities.

This connector is available in the following products and regions:

Service	Class	Regions
Logic Apps	Standard	All Logic Apps regions except the following:      -   US Department of Defense (DoD)
Power Automate	Premium	All Power Automate regions except the following:      -   US Government (GCC High)      -   US Department of Defense (DoD)
Power Apps	Premium	All Power Apps regions except the following:      -   US Government (GCC High)      -   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/finance-and-operations-to-finance-and-scm/

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	200	60 seconds

Actions

Create record	Create a new record in an entity
Delete record	Deletes a single record in an entity
Execute action	Execute action
Get a record	Retrieves a single record
Get list of entities	Retrieves a list of entities
Lists items present in table	Lists items present in table
Update a record	Updates a single record in an entity

Create record

Operation ID:

PostItem

Create a new record in an entity

Parameters

Name	Key	Required	Type	Description
Instance	dataset	True	string	The Dynamics 365 for Fin & Ops instance
Entity name	table	True	string	Entity name
Object	item	True	dynamic	Object to create

Returns

The outputs of this operation are dynamic.

Delete record

Operation ID:

DeleteItem

Deletes a single record in an entity

Parameters

Name	Key	Required	Type	Description
Instance	dataset	True	string	The Dynamics 365 for Fin & Ops instance
Entity name	table	True	string	Entity name
Object id	id	True	string	Unique identifier of the object to delete

Execute action

Operation ID:

ExecuteProcedure

Execute action

Parameters

Name	Key	Required	Type	Description
Instance	dataset	True	string	The Dynamics 365 for Fin & Ops instance
Action	procedure	True	string	Name of action
Parameters	parameters	True	dynamic	Input parameters to the action

Returns

The outputs of this operation are dynamic.

Get a record

Operation ID:

GetItem

Retrieves a single record

Parameters

Name	Key	Required	Type	Description
Instance	dataset	True	string	The Dynamics 365 for Fin & Ops instance
Entity name	table	True	string	Entity name
Object id	id	True	string	Unique identifier of the object to retrieve

Returns

The outputs of this operation are dynamic.

Get list of entities

Operation ID:

GetTables

Retrieves a list of entities

Parameters

Name	Key	Required	Type	Description
Instance	dataset	True	string	The Dynamics 365 for Fin & Ops instance

Returns

Represents a list of tables.

Body

TablesList

Lists items present in table

Operation ID:

GetItems

Lists items present in table

Parameters

Name	Key	Required	Type	Description
Instance	dataset	True	string	The Dynamics 365 for Fin & Ops instance
Entity name	table	True	string	Entity name
Aggregation transformation	$apply		string	A sequence of OData aggregation transformations
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).
Skip Count	$skip		integer	The number of entries to skip (default = 0).
Select Query	$select		string	Specific fields to retrieve from entries (default = all).
Cross Company	cross-company		boolean	Query across companies (default = no).

Returns

The outputs of this operation are dynamic.

Update a record

Operation ID:

PatchItem

Updates a single record in an entity

Parameters

Name	Key	Required	Type	Description
Instance	dataset	True	string	The Dynamics 365 for Fin & Ops instance
Entity name	table	True	string	Entity name
Object id	id	True	string	Unique identifier of the object to update
Object	item	True	dynamic	Object with changed properties

Returns

The outputs of this operation are dynamic.

Triggers

When a Business Event occurs

Triggers a flow when a Business Event occurs in Dynamics 365.

When a Business Event occurs

Operation ID:

SubscribeOnABusinessEvent

Triggers a flow when a Business Event occurs in Dynamics 365.

Parameters

Name	Key	Required	Type	Description
Instance	dataset	True	string	Select an Environment.
Category	businesseventcategory	True	string	Business event category.
Business event	businessevent	True	string	Name of the business event.
Legal entity	legalEntity		string	Name of the legal entity.

Returns

response

object

Definitions

Table

Represents a table.

Name	Path	Type	Description
Name	Name	string	The name of the table. The name is used at runtime.
DisplayName	DisplayName	string	The display name of the table.
DynamicProperties	DynamicProperties	object	Additional table properties provided by the connector to the clients.

TablesList

Represents a list of tables.

Name	Path	Type	Description
value	value	array of Table	List of Tables

object

This is the type 'object'.