cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Screen not updating with other sharepoint list

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

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. 

 

View solution in original post

2 REPLIES 2
Super User II
Super User II

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. 

 

View solution in original post

@Drrickryp  thanks for guidance, this helped!

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (34,708)