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.

Tip

Tip:
Business Central now offers development and operations support for Power Platform in AL-Go and samples to get you started creating your own apps with Power Apps. These features are currently in preview. To learn more, go to Business Central and Power Apps in the developer and IT pro help.

Prerequisites

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

Add Business Central as a data source in Power Apps

These steps add a Business Central table, like customers or items, as the data source of a Power Apps app.

  1. In your browser, go to powerapps.microsoft.com, and then sign in.

  2. In the navigation pane on the left side, select + Create, and then select More data sources on the Create app page.

  3. The Connections the list shows any existing data connections you have.

    • If there's a Business Central connection already, select it, and then select Create.

    • If you don't see a Business Central connection, select + New connection, search for and select Business Central, and then select Create.

    Note

    Note:
    If you want to connect to Business Central on-premises, then you must choose the Business Central (on-premises) connector.

  4. Power Apps connects to your Business Central. Sign in using the Business Central account name and password. If you aren't an administrator of your Business Central, you may have to sign in with another account.

  5. Once you've signed in, Power Apps displays 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, such as PRODUCTION - My Company.

  6. Next, you're presented with a list of tables that are exposed as part of the API for your environment. Select the table that you want to connect to, and then choose Connect.

These so-called tables are exposed as endpoints by the Business Central connector for Power Apps.

Note

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.

At this point, you have successfully connected to your Business Central data and are ready to begin building your Power App. You can always add more screens and connect to more data. Learn more at Create a canvas app from a sample 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.

See also

Create a canvas app from a template in Power Apps
Importing Business Data from Other Finance Systems
Setting Up Business Central
Getting Started Developing Connect Apps for Dynamics 365 Business Central

Find free e-learning modules for Business Central here