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!

Cookies Consent

We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking "Accept All", you consent to our use of cookies.