Application Connector

The application connector allows Microsoft Power Automate, Power Apps, Data Integrator, and Logic Apps to integrate with finance and operations. An external application can use the available trigger and actions to integrate with them.

Prerequisites

We recommend that you read the following topics as a prerequisite to familiarize yourself with connectors before proceeding further

• Connectors
• Data management package REST API
• Open Data Protocol (OData)
• Recurring integrations

Triggers

Business events are exposed using the trigger When a business event occurs. For detailed information about business events, refer to Business events in Microsoft Power Automate and Business events.

Actions

This section describes the actions that are available in the connector.

Get a record

This action can be used to fetch a record for a specific data entity from the target instance.

Instance refers to the URL of the target instance of the application to which the connector must connect. The expected value is to enter the URL without the ‘https://’ prefix or choose one from the drop-down menu. This lists of all the environments that are deployed in the Microsoft Entra tenant for the user account that was used to sign in to the specific client like Power Automate, Power Apps, or Logic App.

Entity name refers to the data entity from which the record must be fetched. The drop-down menu shows the list of data entities from the target environment.

Object ID refers to the primary keys fields that must be specified to uniquely identify the record that must be fetched. The values must be specified as a comma-separated list of values in the order that is defined in the entity.

Create a record

This action can be used to create data records for a data entity.

Instance refers to the URL of the target instance to which the connector must connect. The syntax for this value is to enter the URL without the ‘https://’ prefix or choose one from the drop- menu. This lists of all the environments that are deployed in the Microsoft Entra tenant for the user account that was used to sign in to the specific client like Power Automate, Power Apps, or Logic App.

Entity name refers to the data entity in which the record must be created. The dropdown menu shows the list of data entities from the target environment.

Based on the selected data entity, the list of fields displayed will be vary.

Update a record

This action can be used to update an existing data record for a data entity. The usage is the same as the create a record action.

Delete a record

This action can be used to delete an existing data record for a data entity. The usage is the same as the get a record action.

Execute action

This action can be used to invoke methods on a data entity to perform a business action.

Instance refers to the URL of the target instance to which the connector must connect. The syntax for this value is to enter the URL without the ‘https://’ prefix or choose one from the drop- menu. This lists of all the environments that are deployed in the Microsoft Entra tenant for the user account that was used to sign in to the specific client like Power Automate, Power Apps, or Logic App.

Action refers to the method on the data entity that must be executed. Based on the selected method, the list of fields displayed will be vary. These fields represent the parameters for the selected method.

Get list of entities

This action can be used to get the list of entities for further use in the app that is being developed.

Instance refers to the URL of the target instance to which the connector must connect. The syntax for this value is to enter the URL without the ‘https://’ prefix or choose one from the drop- menu. This lists of all the environments that are deployed in the Microsoft Entra tenant for the user account that was used to sign in to the specific client like Power Automate, Power Apps, or Logic App.

List items present in the table

This action can be used to get the list of records from an entity. This action supports cross-company reading of data.