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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to ge data from an...
Power Apps
Answered

How to ge data from an Entity into Business Central

(0) ShareShare
ReportReport
Posted on by 27

I have created an App where I pulled certain data fields from the Odata feed inside of Business Central for Posted invoices.  I am working on calculation Commision, so I pulled things such as Amount, SalesPerson, sell to customer name, and sell to customer number.  I then have a seperate table that does a lookup to get the correct Commission %, and does the calculation, and creates an excel file with a summary of this information.  

 

Now what I would like to do is a essentially create a "Pending General Journal" inside of Business Central.  I am not sure what the best option is for this.  I also don't really know how to get this data to go back in using power Apps.  

 

Has anyone pushed data  back into Business Central? I feel like this is a simple step that I am just over thinking

Categories:
I have the same question (0)
  • Verified answer
    v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @MaryMThompson ,

    Could you please share a bit more about your scenario?

    Could you please show more details about the "Pending General Journal" that you mentioned?

    Further, do you want to write data back into your Business Central table using PowerApps app?

     

    If you want to write data back into your Business Central table using PowerApps app, here are the solutions:

    1. Generate an app based on your Business Central table, then it would generate three screens -- BrowseScreen, DetailScreen and EditScreen.

    Within the Edit screen, you could save data back to your Business Central table through the Edit form.

    Please check the following blog or video for more details:

    https://community.dynamics.com/nav/b/arounddynamicsnavworld/posts/powerapps-integration-with-microsoft-dynamics-365-business-central-online

    https://www.youtube.com/watch?v=HKT6OsH2SXw

     

    2. If you want to write data back to another Business Central table from an app, I think the Patch function could achieve your needs. Please set the OnSelect property of the "Submit" button to following formula:

    Patch( /* <-- Add new records into your Business Central Table */
     'Your Business Central Table',
    Defaults('Your Business Central Table'),
    {
    Column1: "Xxxx",
    Column2: "xxxx",
    Column3: "xxx",
    ...
    } )
    Patch( /* <-- Edit an existing record within your Business Central Table */
     'Your Business Central Table',
    LookUp('Your Business Central Table', PrimaryColumn = "A specific value"), /* <-- Find the record you want to update */
    {
    Column1: "Xxxx",
    Column2: "xxxx",
    Column3: "xxx",
    ...
    } )

    More details about the Patch function, please check the following article:

    Patch function

     

    Best regards,

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard