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
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

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

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Solution Authors
Top Kudoed Authors
Users online (94,728)