web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Show Business Central service order data in power apps?

(0) ShareShare
ReportReport
Posted on by 60

I need to expose service module data in power apps app and allow business central team members to update service orders and do some other things. When i connect business central with power apps i don't see service orders data or any data related to service module. I need a solution to built my app.

I have the same question (0)
  • Verified answer
    Renato Fajdiga Profile Picture
    1,853 on at
    RE: Show Business Central service order data in power apps?

    Hi,

    you need to build custom API, custom connector to be able to see data in power apps that are not available out of the box.

    One good reading for the start community.dynamics.com/.../how-to-create-custom-apis-for-business-central-even-from-macos

    Best regards,

    Renato  

  • unaseer Profile Picture
    60 on at
    RE: Show Business Central service order data in power apps?

    Hi Renato

    Any reason why there is no out of the box solution.

  • Suggested answer
    Stefano Demiliani Profile Picture
    37,166 Most Valuable Professional on at
    RE: Show Business Central service order data in power apps?

    Simply because there are no exposed APIs for these entities. As said by Renato, create your custom API pages with data you want and then create a custom connector based on these custom APIs.

  • Community Member Profile Picture
    on at
    RE: Show Business Central service order data in power apps?

    In your browser, navigate to powerapps.microsoft.com, and then sign in.

    In the left navigation pane, choose New App.

    Choose your editor, PowerApps Studio for Windows or PowerApps Studio for Web.

    PowerApps Studio for Windows is a desktop application used to create and publish PowerApps. The PowerApps Studio for Web is the online solution used to create and publish PowerApps.

    The next step to create a PowerApp is to select your data. Choose the Arrow icon then choose the New connection option in the upper left side of the page.

    In the list of available connections, choose Dynamics 365 Business Central.

    PowerApps will display a connection page that prompts you for the information that is required to connect to your Business Central data. To connect, you must specify an OData URL, username, password, and company name.

    For the OData URL, you can copy the OData V4 URL of any of the web services that are listed in the Web Services window in Business Central, such as mycompany.businesscentral.dynamics.com:7048/.../.

    For the Company Name, use the name that is shown in the Name field in the Company Information window in Business Central, such as My Company.

    For the username and password, use the name and web service access key that are specified for your account in the Users window in Business Central. For example, your username is ADMIN, and the web service access key that serves as your password is EgzeUFQ9Uv0o5O0lUMyqCzo1ueUW9yRF3SsLU=.

    Choose the Connection button to continue. PowerApps will display a default dataset for Business Central. Choose the Default dataset.

    PowerApps will display a list of tables that are available from Business Central.

    Alternatively, create a new web service URL in Business Central by using the Create Data Set action in the Web Services window, using the Set Up Reporting Assisted Setup guide, or by choosing the Edit in Excel action in any lists.

    Choose the table that you want to use for your PowerApp, and then choose the Connect button.

    Repeat the previous steps to add additional Business Central data to your Power BI Pro data model.

    Admin

    Apps4rent

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 2,568

#2
Sumit Singh Profile Picture

Sumit Singh 2,536

#3
YUN ZHU Profile Picture

YUN ZHU 2,015 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans