Business Central Web Services Page not showing in Power Apps

(0) Share

Report

Posted on by Power Platform Comm...

Hi All,

I am trying to use the Business Central (on-premises) connector in PowerApps to access data for an app.

We have exposed a page (Purchase Line) through Business Central Web Services but are currently unable to see it in PowerApps when we click on the Business Central (on-premises) connector.

In fact, the connector always populates the same list of tables under its "choose a table" option, regardless of how many new pages we expose on the Web Service. Any help on this issue?

Thanks

I have the same question (0)

All responses (7)

Answers (0)

Fabfab 85 on at

Like (0)

Report

Hi,

have you tried with a custom connector ?

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

Yes, tried with a custom connector. Apparently there is a bug which prevents data from being viewed in PowerApps when the URL path contains special characters like commas or parentheses

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

If the amount of data is not too extensive, you could use a power automate to request the data via an odata call.

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

Hi Rashid,
I have the same issue withe BC Connector. Did you manage to solve this issue?
Thanks

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

If the issue is special characters, why not change the BC company name?
Other ways to connect e.g. OData web-services will must likely also struggle with specific characters

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

For me its not the company name, it the standard BC connector.

When you add a new web service for a table in BC, that table is not available to select when using the BC connector.

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

aha I see. The BC connecter exposes (some?) API pages, not web services that you publish.
You can still use the web services as Rest API on the OData endpoint.
More info on API(V2.0) for Dynamics 365 Business Central - Business Central | Microsoft Docs
https://docs.microsoft.com/en-us/connectors/dynamicssmbonprem
OData Web Services Data Modification - Business Central | Microsoft Docs

If you have onprem BC, than make sure your ODATA endpoint is reachable through your firewall. Otherwise Cloud Flows won't be able to reach it.

Was this reply helpful? Yes No