Power Platform Community Forum Thread Details

Hi All,

I want to create a Power App where my database is a third-party ERP system (eMagic). If any changes are made in the Power App (e.g., creating a new entry), they should automatically be added to the ERP system, and vice versa. If this is possible, please provide a solution or suggest an alternative method.

Thanks

Categories:

Building Power Apps

Integrating Power Apps with a third-party ERP system, such as eMagic, requires setting up a two-way sync mechanism.

You need to create a custom connector in Power Apps for the ERP system’s API. Many ERP systems provide RESTful or SOAP APIs for data operations (like creating, updating, and retrieving records).

Check if eMagic offers an API for external integrations.
In Power Apps, go to Data > Custom Connectors and create a new connector.
Use the API documentation of eMagic to configure the connector to interact with the required endpoints.
This custom connector can then be used within Power Apps to create, read, update, and delete records in eMagic directly.

Use Power Automate (formerly Microsoft Flow) to automate the sync between Power Apps and eMagic:

Create a Power Automate flow that triggers when a new entry is created or updated in Power Apps.
In the flow, use HTTP actions to call the eMagic API to reflect changes from Power Apps in eMagic.
For syncing data from eMagic to Power Apps, schedule another Power Automate flow that retrieves new/updated records from eMagic and pushes them into the Power App's data source.

If eMagic’s database is on-premises, use an on-premises data gateway to connect securely.

Install and configure the data gateway in your network where the eMagic database is hosted.
Configure Power Apps or Power Automate to access the on-premises database through this gateway.
Build flows or use the gateway as a connector in Power Apps to perform CRUD operations on the eMagic data.

Use middleware like Azure Logic Apps, Zapier, or MuleSoft for complex integrations if eMagic supports these platforms.

Set up a Logic App to listen for changes in Power Apps and eMagic.
Configure actions in the middleware to sync data between Power Apps and eMagic, making sure both systems stay updated.

If eMagic ERP supports embedding or has a UI API, you could embed Power Apps within the ERP or vice versa.
This way, any changes made in the Power App are instantaneously visible in the ERP environment.

Each of these methods allows for some degree of integration between Power Apps and eMagic. The best approach depends on the API capabilities of eMagic and your organization's infrastructure. If eMagic lacks an API, you may need to explore alternatives, such as exporting data periodically.