Patch one table on top of another

(0) Share

Report

Posted on by SmoothOperator

Tried my best to find a title, but not sure how to post it exactly... So...

I have a table 1

Name	ID
John	1
George	2
Jim	3
Bill	4

and I have another table 2

Name	ID
Chris	1
Patric	2
Francois	3

I want to always keep the second table, and put on the beginning of the second table the first one and adjust the ID accordingly.

Preferably I would like to do that with collections..

The result I want is :

John	1
George	2
Jim	3
Bill	4
Chris	5
Patric	6
Francois	7

Hope you understood the needed result!

Thank you in advance 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

eka24 20,923 on at

Like (0)

Report

@SmoothOperator

ClearCollect(JoinedTable,Table1,Table2)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
SmoothOperator 48 on at

Like (0)

Report
if both tables have different columns though? I believe that
ClearCollect( JoinedTable, Table1,Table2 )
does not work and merges them. They should be exactly the same..
any thoughts?

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Your table had same columns. Did it work?

If different column names we can use AddColumns

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

eka24 20,923 on at

Like (0)

Report

Try this:

ClearCollect(JoinedTable,Table1,RenameColumns(Table2,"Name2","Name","ID2","ID"));

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
SmoothOperator 48 on at

Like (0)

Report

I did this but with a ShowColumns() way and managed to make them both the same column collections and then used the intitial way you proposed

Thank you!

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

That is fine.

Thanks

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No