Announcements
Hi,
I'm not getting any data from the Business Central connector in Power Apps for SalesOrderLines. I can get the SalesOrders and other tables, but SalesOrderLines seems to need a parameter of documentId. I know that Sales Order number or Id is the related field, but there doesn't seem to be a way to pass this information to the datasource. If I try to use a filter it errors out on needing a documentId for the query. I've used the CDS connector in Power Apps extensively and it's frustrating to go to Business Central and the basics are not the same. I should be able to filter the table normally and get the data. Does anyone have a way to get this data?
Hi @paijax ,
Please check if below blog could help:
https://community.dynamics.com/business/b/dynamics365businesscloudfronts/posts/linking-of-sales-order-and-sales-order-lines-in-microsoft-powerapps
Regards,
Mona
This might solve the problem - when the 2020 Wave 1 release is out. https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/dynamics365-business-central/business-central-integration-common-data-service" target="_blank">https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/dynamics365-business-central/business-central-integration-common-data-service
Thanks for the heads up on this one. I'll watch for it and hopefully it expands the availability of BC data.
@paijax Has this been resolved in the latest release ? because I have the same issue
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 85
WarrenBelz 76 Most Valuable Professional
Kalathiya 38 Super User 2026 Season 1