Gallery View Based on a Gallery Selection Two Different Entities

[Anonymous]

Hello,

I am trying to build a PowerApp to view orders people make and the line items with them. Once the order is selected I would like to have a gallery to view the items on the order.

So Gallery1 item is selected and has 3 items. The next screen shows the form with the details of the order, and have Gallery2 display the items on the order.

This is what I have and I am getting an error. I can do the Purchased Products or the Gallery Selected but not both. (The BrowseGallery1 is looking at the order)

Filter('Purchased Products', BrowseGallery1.Selected)

Thanks

Aaron

[Drrickryp · Accepted solution]

Hi @Anonymous 

Your app seems very similar to the Northwind Traders database app used as an example of how to design with CDS.  I suggest that you look closely at it.  I learned a great deal from going through the exercise. https://powerapps.microsoft.com/en-us/blog/northwind-traders-relational-data-sample/