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

Operation ID:

PostItem

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

Operation ID:

DeleteItem

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

Operation ID:

GetItem

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

Operation ID:

GetTables

Retrieves Dynamics NAV item types

Returns

Represents a list of tables.

Body

TablesList

Update item

Operation ID:

PatchItem

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]

Operation ID:

GetOnNewItems

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]

Operation ID:

GetOnDeletedItems

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]

Operation ID:

GetOnUpdatedItems

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