2 May’19

D365 Business CentralLinking of Sales Order and Sales Order Lines in Microsoft PowerApps.


In this blog I will demonstrate that how the Sales Order and its corresponding Sales Order Lines can be linked together in the Microsoft PowerApps.


  1. Microsoft PowerApps


  1. Create two galleries within the PowerApps and for the first gallery create a display form with Sales Order as the Data source.
  2. In the second gallery, the Sales Order Lines is the Data source.
  3. Now select the second gallery, and write the following formula to display the corresponding Sales Order lines: Filter(SalesOrderLines,’Document No.’ exactin                                      DataCardValue2.Text)                                                                                    where DataCardValue2.text contains the value of ‘No.’ field of the Sales Order on the basis of which the Sales Order and its lines are related. The exact in keyword is used to check whether both the fields are matching exactly.

Written by

Dhruv Mehta

Trainee Software Engineer

Leave a Reply

Your email address will not be published. Required fields are marked *

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Expenses in PSA for Fixed Bid and T&M contracts

    23 August’ 2019

    Problem Definition: One of my clients decided to use Expense module in PSA and to his surprise he could see the amount v...

    Read more
  • Setup Dockers

    23 August’ 2019

    Docker is an independent container platform that enables organizations to seamlessly build, share and run any applicatio...

    Read more
  • Qualify Lead in D365 CE: Select which entity records should be created

    20 August’ 2019

    Wave 2019 Updates brought some really sought-after features. Another one which I would like to bring up is the Lead Qual...

    Read more
  • Early Opt-in for October 2019 Wave 2 Updates

    20 August’ 2019

    August 2, 2019 was when the Wave 2 Updates were to be out. And here we are! By now, you should have gotten the option to...

    Read more
  • Setting Unified Interface App Icons

    20 August’ 2019

    Default App Icons for typical D365 environment look like these.But here’s what you can do to change these to put...

    Read more
  • We respect your privacy.
  • This field is for validation purposes and should be left unchanged.