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
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (4,674)