Partilhar via


Dynamics NAV (Preview)

Dynamics NAV is a business management solution for small and mid-sized organizations that automates and streamlines business processes and helps you manage your business. You can use this connector with Dynamics NAV 2017 or later.

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)
Connector Metadata
Publisher Microsoft
Website https://dynamics.microsoft.com/nav-overview/

Creating a connection

The connector supports the following authentication types:

Default Parameters for creating connection. All regions Shareable

Default

Applicable: All regions

Parameters for creating connection.

This is shareable connection. If the power app is shared with another user, connection is shared as well. For more information, please see the Connectors overview for canvas apps - Power Apps | Microsoft Docs

Name Type Description Required
OData Feed URL string OData Feed URL True
Username securestring Username True
Password securestring Password True
Company string Company True

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

Create item

Creates a DynamicsNavision item

Delete item

Deletes a DynamicsNavision item

Get item

Retrieves a DynamicsNavision item

Get item types

Retrieves Dynamics NAV item types

Update item

Updates an existing DynamicsNavision item

Create item

Creates a DynamicsNavision item

Parameters

Name Key Required Type Description
Table name
table True string

Name of Dynamics NAV table

Row
item True dynamic

Row to insert into the specified table in Dynamics NAV

Returns

The outputs of this operation are dynamic.

Delete item

Deletes a DynamicsNavision item

Parameters

Name Key Required Type Description
Table name
table True string

Name of Dynamics NAV table

Row id
id True string

Unique identifier of the row to delete

Get item

Retrieves a DynamicsNavision item

Parameters

Name Key Required Type Description
Table name
table True string

Name of Dynamics NAV table

Row id
id True string

Unique identifier of the row to retrieve

Returns

The outputs of this operation are dynamic.

Get item types

Retrieves Dynamics NAV item types

Returns

Represents a list of tables.

Body
TablesList

Update item

Updates an existing DynamicsNavision item

Parameters

Name Key Required Type Description
Table name
table True string

Name of Dynamics NAV table

Row id
id True string

Unique identifier of the row to update

Row
item True dynamic

Row with updated values

Returns

The outputs of this operation are dynamic.

Triggers

When a record is created [DEPRECATED]

Triggers a flow when a record is created in Dynamics NAV

When a record is deleted [DEPRECATED]

Triggers a flow when a record is deleted in Dynamics NAV

When a record is modified [DEPRECATED]

Triggers a flow when a record is modified in Dynamics NAV

When a record is created [DEPRECATED]

Triggers a flow when a record is created in Dynamics NAV

Parameters

Name Key Required Type Description
Table name
table True string

Name of Dynamics NAV table

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

Returns

The outputs of this operation are dynamic.

When a record is deleted [DEPRECATED]

Triggers a flow when a record is deleted in Dynamics NAV

Parameters

Name Key Required Type Description
Table name
table True string

Name of Dynamics NAV table

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

Returns

The outputs of this operation are dynamic.

When a record is modified [DEPRECATED]

Triggers a flow when a record is modified in Dynamics NAV

Parameters

Name Key Required Type Description
Table name
table True string

Name of Dynamics NAV table

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

Returns

The outputs of this operation are dynamic.

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