cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bloodoff
Kudo Commander
Kudo Commander

Merge two single-column tables into one without "each record of the table is added as a separate record"

Hi PA Community,

 

Is there a simple way to merge two tables into one line by line, i.e without "each record of the table is added as a separate record"? (the only thing in common is exactly the same number of rows)

Wish these tables had an internal index which I believe they don't, which people have asked for.

 

What I have:

Table1		Table2
------		------
A		1
B		2
C		3
...		...

What's needed:

Table3
------------------------
Column1		Column2
-------		-------
A		1
B		2
C		3
...		...

Sorry, if it's super simple, sometimes we all overcomplicate things 🙂

 

PS. I do have a workaround for my specific PowerApps Form but that doesn't answer my question.

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User
Super User

@bloodoff 

Sure thing...here's a pretty basic formula for that:

 

 

Clear(oneCollection);
ForAll(Table1, 
Collect(oneCollection,
{Column1:Value,
Column2:Last(FirstN(Table2, CountRows(oneCollection)+1)).Value
}
)
)

 

I hope that helps point you in the right direction.

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

3 REPLIES 3
RandyHayes
Super User
Super User

@bloodoff 

Sure thing...here's a pretty basic formula for that:

 

 

Clear(oneCollection);
ForAll(Table1, 
Collect(oneCollection,
{Column1:Value,
Column2:Last(FirstN(Table2, CountRows(oneCollection)+1)).Value
}
)
)

 

I hope that helps point you in the right direction.

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Thanks!

That's a workaround for a missing index column, isn't it? 🙂

@bloodoff 

Yes you can.  However, ForAll's are expensive.  So performance can take a hit if overused.

I use this indexing in places where there are small amounts of data to display - like a filtered Gallery.  And usually only to generate an index for even/odd numbering so that I can highlight alternate rows.  It gets tricky sometimes doing that, but...yep...it can be done.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (5,185)