Best Approach for PowerApps Integration with Business Central

1. Use Middleware Tables in Business Central

• Create custom middleware tables in BC to act as a secure staging area between PowerApps and core BC tables.

• This avoids giving PowerApps direct access to sensitive or complex ERP data.

Why it’s best:

• Keeps core BC clean

• Easier data validation

• Fully controlled by Business Central logic

2. Expose Middleware Tables via OData Web Services

• Publish the middleware tables as OData V4 web services from Business Central.

• PowerApps uses the standard Business Central connector to connect to the published web service.

Benefits:

• No custom connector needed

• Secure access via Azure AD authentication

• Supports real-time interaction with BC

3. PowerApps Handles UI and Workflow

• Use PowerApps to build intuitive, mobile-ready forms and dashboards.

• Let users input or view data that maps directly to the middleware tables.

Example:

• An employee submits a leave request → goes to middleware → BC processes it → status flows back to PowerApps

4. Process Middleware Data via AL Code in BC

• Set up AL codeunits or events to handle incoming data.

• Logic includes:

  • Validation

  • Posting to main BC tables

  • Error handling and logging

5. Send Response Back to PowerApps

• PowerApps can read a “status” field from the middleware table (e.g., "Processed", "Error", etc.)

• This provides feedback and confirmation to the user.

• Security & Governance Best Practices:

• Use Azure Active Directory (AAD) for authentication

• Limit PowerApps access only to middleware tables

• Log and audit every transaction in BC for compliance

• Document the data flow and business logic clearly

Schedule your FREE demo session today!