Working with Microsoft Dynamics 365 Business Central customizations in PowerApps using CDS and OData

March 12 2019

In this article, I will demonstrate how to fetch data from a custom table created in Microsoft Dynamics 365 Business Central into PowerApps using the Common Data Service (CDS) and OData.

The table that was created in Business Central was fetched into a custom entity (MatchingLists) created in CDS. This allows for the creation of a local database in PowerApps for storing the entity data with OData to fetch and integrate the data. MatchingList is a custom table that I created and which I wanted to use with PowerApps. In this article, I will explore how I used CDS and OData to get that custom table in Business Central aligned with PowerApps and hopefully it will help other users to get a sense of how customizations in Business Central can be consumed in PowerApps.

Steps

1. Create a custom entity within CDS whose data you want to retrieve from Business Central.

create_a_custom_entity_in_cds

2. Add the fields required in the table along with their respective data types.

add_the_fields_and_their_respective_data_types

3. Publish the custom table in Business Central as a Web Service and make a note of the OData V4 URL that will be needed later for OData integration. At this time there are no permissions associated with it.

publish_the_custom_table_in_business_central_as_a_web_service

4. You can use the OData URLto check the data in the table in Business Central.

use_the_odata_url_to_check_table_data_in_business_central

5. In PowerApps, go to the entity list and select your entity, click on the Get data button to provide the OData integration details that allow us to retrieve the data from Business Central. With this step we will associate the custom table created in Business Central with the entity that is created in PowerApps.

select_from_entity_list_and_click_get_data

6. After clicking on 'Get data', select the source using which you want to fetch the data. In this case we make use of OData as the format when fetching data from Business Central.

select_the_source_for_fetching_data

 7. In this step we enter the OData URL of the custom table from Business Central and the organization credentials and click on the next button.

About Dhruv Mehta

Dhruv Mehta is a Software Engineer with CloudFronts Technologies. Being a fresh, young and innovative mind, Dhruv has shown his capability to learn the Microsoft Dynamics ERP systems. Even though new to this field, his inquisitiveness has led him to successfully deliver on the live client projects related to ERP implementations. His further learning has gained him extremely valuable insights into the Microsoft Power Technologies especially PowerApps, MS Flows and BI.

CloudFronts is a Microsoft Certified Gold Partner which offers complete Dynamics 365 (Customer Engagement, Finance and Operations, Business Central) implementations, Power BI Analytics, Office 365 and Azure Infrastructure services. The team has deep expertise in delivering and supporting the customers through all aspects of their implementation from strategic technology consulting and road-map, requirements assessments, project implementation, training, migration to post go live managed services and support. The company has vast experience in digitally transforming corporates in sectors such as banking & financial services, professional services, pharmaceutical, manufacturing, F&B, retail, agro-tech, non-profit and several others. CloudFronts commenced its operations in the year 2012 to empower organizations around the world, do more with technology.

Check out our customer success stories here: https://www.cloudfronts.com/customer-success/

More about Dhruv Mehta