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 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.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

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.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

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