Plaza 365
Plaza 365

No results found for your search

RegisterLog in

12

How to access/display Business Central data directly in Power Apps without using Dataverse and standard Power Platform connector – Call HTTP Request via Power Automate

Visit article

#access

#apps

#automate

#connector

#data

#dataverse

#platform

Dynamics 365 Business Central

Category

Dec 16, 2024

Published date

Text

Article Type

AI Summary

  • The article discusses two main ways to connect Business Central data with Power Apps: using the standard Power Platform connector or through Dataverse.
  • The standard Power Platform connector allows for real-time data access through BC's APIs, while connecting through Dataverse involves an intermediate layer and custom tables integration.
  • The standard connector requires a BC license, while Dataverse requires a Dataverse license such as Power Apps Premium.
  • The article introduces a third method involving HTTP requests via Power Automate to access BC data as a response, allowing users without a BC license to access data in Power Apps.
  • Detailed steps are provided on setting up the HTTP request flow in Power Automate, obtaining an access token, and accessing BC's API to retrieve customer data in Power Apps.
  • The process involves authentication using OAuth 2.0, obtaining a client ID and client secret from Azure Portal, and using the access token to access BC's API.
  • The article also covers parsing JSON data, selecting and mapping fields, and sending back HTTP responses to Power Apps to display the retrieved data in a list format.
  • A step-by-step guide is provided on creating a Power App, adding the flow created in Power Automate, and displaying the BC data in a data table for real-time synchronization without the need for Dataverse.

Registered users can view the full text for FREE!

Sign In Now!