Screen not updating with other sharepoint list

[Mishatandon]

Hi community,

I have created a Thank You screen and it should display ( data table) with the information  from the previous screens(forms) that have been submitted by the user.

When I built the first screen where the user inputs value in a form its getting displayed on the Thank you screen.

I am not able to create a dynamic link on this thank you page that can populate the data table from the other input form data. 

Formula I have used on the thank you screen in data table is :

Filter('ABC list',User().Email in Emailid)

I want to add EFG list also to be displayed on the data table?

Any suggestion how I can either build in existing data table?

Please let me know in case of any queries.

[Drrickryp · Accepted solution]

Hi @Mishatandon 

You would do that with the AddColumns() function on the Items property of the data table based on a common field in both tables, say A1 in the second table. 

AddColumns(ABC, "columnnameD", Lookup(EFG,A1=A,D),"columnnameE", Lookup(EFG,A1=A,G),"columnnameG", Lookup(EFG,A1=A,G))

A good choice for A and A1 would be the ID column in ABC. 

[Mishatandon]

@Drrickryp  thanks for guidance, this helped!