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

Announcements

Community site session details

Community site session details

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

Getting Sales Order lines in Power Apps

(4) ShareShare
ReportReport
Posted on by 6,533 Moderator

 I am a noob in BC. 

We are working on a Power App Canvas app to read and write sales orders into BC. We are able to create sales order Headers and Lines using Power App and we are able to read the Sales Order headers. However, the SalesOrderLines table returns blank even when we get the records without any filter.

The Get Record V3 entity has Row ID as the mandatory field which is a unique identification number in the SalesOrderLines table in BC.

What is the best way to get all sales order lines in a SO, if the only information we have is the document ID/Sales Order number? 

pastedimage1677573568689v1.png

I have the same question (0)
  • Suggested answer
    DAnny3211 Profile Picture
    11,403 Super User 2026 Season 1 on at
  • Shafeeque P. Profile Picture
    6,533 Moderator on at

    Thanks for pointing me to this. Will give that a try and get back with the result.

  • Verified answer
    YUN ZHU Profile Picture
    97,433 Super User 2026 Season 1 on at

    Hi, sorry it's not in English, but hopefully this video below can give you some new hints.

    https://www.youtube.com/watch?v=5Lc4pKv0fHs

    pastedimage1677635277916v1.png

    Thanks.

    ZHU

  • AW-27021119-0 Profile Picture
    8 on at
    Any other responses to this?  The documentation seem somewhat scant.
    The video/link are not quite what I'm needing.
     
    I've a similar intention in that I wish to use the "documentId" of a parent Sales Invoice to query/filter its set  of Sales Invoice Lines. 
    Supplying the filter with this GUID should be sufficient to return the associated set of Sales Lines surely, but in my case nothing is returned.
     
     
  • IC-09040208-0 Profile Picture
    3 on at
    why is this so hard? i've been searching high and low for an answer to this. has anyone on this thread found a solution?

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 Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,029 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,044 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 1,026 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans