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

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

  2. On the Home page, in the Start from data section, choose the Other data sources tile.

    This opens Power Apps Studio. On first login, you must specify the country/region.

  3. 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.

  4. 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, such as PRODUCTION - My Company.

  5. Next, you will be 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

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 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.

Note

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

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