RE: Add a Custom Table from Business Central (on prem) to Power Apps
1. Create a custom entity within Common Data Service(CDS) whose data you want to retrieve from Business Central.
2. Add the fields with their required data types.
3. Get Data from Business Central using OData Integration.
4. Go to web services in Business Central, add the custom page in the web services and use its OData V4 URL.
5.Enter the OData URL and the Organization credentials.
6. You will be shown the list of tables in each and every company.
7. Go to the table whose data you want to get into PowerApps, and select that table.
8. Next is to select the entity to be mapped with this table and field by field mapping of the same.
9. Refresh can be set manual or automatically, if automatic then select the time.
10. Create a list structure to dsiplay the table.
Admin
Apps4rent | o365cloudexperts
