Linking 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.

Share Story :




Enter your email address to follow this blog and receive notifications of new posts by email.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.