Connecting to Your Business Central Data to Build a Business App Using Power Apps

You can make your Business Central data available as a data source in Power Apps.

Note

You must have a valid account with Business Central and with Power Apps.

To add Business Central as a data source in Power Apps

In your browser, navigate to powerapps.microsoft.com, and then sign in.
On the Home page, choose the Apps, Create an app and Canvas to create a new canvas app. This app will be designed for use on a mobile device, but you can also choose to use another template.

The next step to create a Power App is to select your data. Choose the Arrow icon then choose the New connection option in the upper left side of the page.
In the list of available connections, choose Business Central, and then choose the Create button.

Power Apps will connect to your Business Central using the credentials that you are signed in with. If you are not an administrator of your Business Central, you may have to sign in with another account.
Power Apps will display a list of Environments and companies that are available from Business Central. Choose the environment and company that contains the data you want to connect to. Next, you will be presented with a list of APIs. Select the API you want to connect to.

These so-called tables are part of the Business Central API. You do not have to configure the end points yourself - the Business Central connector for Power Apps does it for you.

Note

If you want to include data from other tables in Business Central in your app, then you must work with a developer to define a custom API in Business Central and then consume that custom API through a custom connector in Power Apps. For more information, see Create a custom connector from scratch.

At this point, you have successfully connected to your Business Central data and are ready to begin building your PowerApp. You can add additional screens and connect to additional data from your Business Central. For more information, see Create a canvas app from a template in Power Apps.

When you have designed and built your app, you can share it with your colleagues. For more information, see Save and publish a canvas app in Power Apps.

Note

If you want to connect to Business Central on-premises, then you must choose the Business Central (on-premises) connector in step 3.

Connecting to Your Business Central Data to Build a Business App Using Power Apps

Note

To add Business Central as a data source in Power Apps

Note

Note

See Also