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)
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

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

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

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

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

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

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

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

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'.