Creating multiple table display view from gallery

[Kirsten2]

I got a good head start with help previously here where I set up the gallery from multiple tables:

Solved: Re: Joining multiple tables for gallery view - Power Platform Community (microsoft.com)

But now, I want to display the detail information from the gallery on another screen. It's like over 50 fields combined from the two data tables from SharePoint.

For the View form screen showing the details, I set the "DataSource" property of the form to:

AddColumns(
    Orders As Main,
    "CustomerDetails",
    LookUp(
        Customers, 
        Email = Main.CustomerEmail
    )
)

And I set the "Item" property to:

Gallery3.Selected

I am getting no errors, but the only fields that are showing up on the form are from the Orders. I am getting no Customers fields and when I search to add fields in the side bar, the Customers fields do not show up, and I want to show them too.

Is there a way to do this in PowerApps? Or do I need to have a SharePoint table in the backend that combines both tables?

[Kirsten2]

@LaurensM thanks for your help with the last question! Since this is related, including you on this one, if you have any idea on how to solve this problem. I really appreciated your help thus far.

[LaurensM · Accepted solution]

Hi @Kirsten2,

Forms operate on the actual Data Source itself. They expect e.g. an Excel table or SP list as their Datasource property. Objects or Lists defined within the app itself by adding columns or creating collections are not taken into account within the Form.

A possible workaround would be using 2 view Forms: the first one will show the Order data and the second one will show the Customer data linked to the CustomerDetails column.

Form 1 (Orders):

Datasource property

Orders

Item property

//Change ID to a unique field of the Orders list
LookUp(Orders, ID = Gallery1.Selected.ID)

Form 2 (Customers)

Datasource property

Customers

Item property

Gallery1.Selected.CustomerDetails

Important note regarding app performance: It is not recommended to reference controls (Gallery1) from another screen, since the app is then obliged to keep the other screen in memory. When navigating to the second screen you could save the selected Gallery record to a variable and replace all the current Gallery1 references.

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!

[Drrickryp]

@Kirsten2 

Another option is to not use a form at all and just place your labels on a blank screen wherever you like and reference your gallery directly in the text property of the labels.