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
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

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