Getting Sales Order lines in Power Apps

(4) Share

Report

Posted on by Shafeeque P.

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?

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

DAnny3211 11,397 on at

Like (1)

Report

hi

look this

learn.microsoft.com/.../enhance-power-automate-power-apps-connector-support-filter-search

DAniele

Was this reply helpful? Yes No
Shafeeque P. 6,533 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,649 Super User 2025 Season 2 on at

Like (2)

Report

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

Thanks.

ZHU

Was this reply helpful? Yes No
AW-27021119-0 8 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
IC-09040208-0 3 on at

Like (1)

Report

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?

Was this reply helpful? Yes No