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

Merge five single column tables into one

Hi,

I have a scenario where there are 5 different collections having only single column table.

Let's name them coll1, coll2, coll3, coll4, coll5

All contains equal numbers of row count.

How to merge all those in new collection named collFinalReview?

After it is merged collFinalReview will be patched to SPO list.

3 ACCEPTED SOLUTIONS

Accepted Solutions
WarrenBelz
Super User
Super User

Hi @AnkitShah55 ,

Assuming the single column is the same name and type on them all

ClearCollect(
   colFinalReview, coll1, coll2, coll3, coll4, coll5
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

eka24
Super User
Super User

Try:

ClearCollect(collFinalReview,coll1, coll2, coll3, coll4, coll5)

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

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.

View solution in original post

AnkitShah55
Advocate III
Advocate III

By the way to merge collections I used following way

ClearCollect(collFinalReview, {a:"", b:"", c:"", d:"", e:""});Clear(collFinalReview);

ForAll(ckA, 
 Collect(collFinalReview, {
 a:Last(FirstN(ckA, CountRows(collFinalReview)+1)).Result,
 b:Last(FirstN(ckB, CountRows(collFinalReview)+1)).Result,
 c:Last(FirstN(ckC, CountRows(collFinalReview)+1)).Result,
 d:Last(FirstN(ckD, CountRows(collFinalReview)+1)).Result,
 e:Last(FirstN(ckE, CountRows(collFinalReview)+1)).Result}
 )
);

 @eka24 @WarrenBelz  

View solution in original post

8 REPLIES 8
WarrenBelz
Super User
Super User

Hi @AnkitShah55 ,

Assuming the single column is the same name and type on them all

ClearCollect(
   colFinalReview, coll1, coll2, coll3, coll4, coll5
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

eka24
Super User
Super User

Try:

ClearCollect(collFinalReview,coll1, coll2, coll3, coll4, coll5)

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

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.

AnkitShah55
Advocate III
Advocate III

Thanks @eka24 @WarrenBelz 

That worked !!

Is there any way to get SPO list item count using Flow but without using Sharepoint>Get Items action? Because GetItems action takes too long time if list size is large(2000+).

AnkitShah55
Advocate III
Advocate III

By the way to merge collections I used following way

ClearCollect(collFinalReview, {a:"", b:"", c:"", d:"", e:""});Clear(collFinalReview);

ForAll(ckA, 
 Collect(collFinalReview, {
 a:Last(FirstN(ckA, CountRows(collFinalReview)+1)).Result,
 b:Last(FirstN(ckB, CountRows(collFinalReview)+1)).Result,
 c:Last(FirstN(ckC, CountRows(collFinalReview)+1)).Result,
 d:Last(FirstN(ckD, CountRows(collFinalReview)+1)).Result,
 e:Last(FirstN(ckE, CountRows(collFinalReview)+1)).Result}
 )
);

 @eka24 @WarrenBelz  

 

Hi @AnkitShah55 ,

Did you still want the answer to your earlier question - I see you are using CountRows in your code

Hi @WarrenBelz @eka24 

Is there any way to get SPO list item count using Flow but without using Sharepoint>Get Items action? Because GetItems action takes too long time if list size is large(2000+).

Well I don't know how you got around the Get items flow. But I suggest you don't pull all the columns in your Sharepointlist during the flow. At most 2 Columns should be selected in the flow to make it faster.

You can watch this video from Audrey

https://youtu.be/IOG0AecA6xE

 

Finally if this also doesn't help, put your request on the Power Automate Platform.

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

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.

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,265)