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

Merge 3 identical tables into a new table

 

Hello i am trying to find a solution for my app 

 

I have 3 indentical Sharepoint databases ( Same Col names ) but different data 
i Need to merge them down to One big Table with indentican Col names 

So i have this Cols in my 3 tables and in my new 4 table i need the same names with all the data 

ClassID , Name ,Telephone , Program

 

pls anyone 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
zmansuri
Super User
Super User

OnClick of button:

 

ClearCollect(col1,List1);

ClearCollect(col1,List2);

ClearCollect(col1,List3);

ClearCollect(colFinal,col1,col2,col3);

 

This will create a collection named colFinal which will have all the data from those 3 lists and same column names.

View solution in original post

3 REPLIES 3
zmansuri
Super User
Super User

OnClick of button:

 

ClearCollect(col1,List1);

ClearCollect(col1,List2);

ClearCollect(col1,List3);

ClearCollect(colFinal,col1,col2,col3);

 

This will create a collection named colFinal which will have all the data from those 3 lists and same column names.

View solution in original post

Thank you sir , this maked my day 🙂

Glad it worked

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,024)