cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NewNW
Advocate II
Advocate II

Merge rowsn in Data Table / Collection

Hi All,

I have the following Data table , where Item = RequestCollection.

 

NewNW_0-1659666137391.png

 

Can someone please tell me how to display the data table as follows?

Thank you. 

 

NewNW_1-1659666253604.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
Super User
Super User

Hi @NewNW ,

Try this

AddColumns(
   GroupBy(
      RequestCollection,
      "Name",
      "ID",
      "Status",
      "ApprovalID",
      "Data"
   ),
   "Approvers",
   Concat(
      Data,
      Approver,", "
   )
)

 

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.

Visit my blog Practical Power Apps

View solution in original post

3 REPLIES 3
WarrenBelz
Super User
Super User

Hi @NewNW ,

Try this

AddColumns(
   GroupBy(
      RequestCollection,
      "Name",
      "ID",
      "Status",
      "ApprovalID",
      "Data"
   ),
   "Approvers",
   Concat(
      Data,
      Approver,", "
   )
)

 

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.

Visit my blog Practical Power Apps

@WarrenBelz 

Thank you very much for your quick reply.

I m getting the following error. FYI- Collection name has changed, as shown below image ( FinalColl1 ).

thank you very much for your guidance. 

 

NewNW_0-1659669150689.png

My FinalColl1 is as follows.

NewNW_1-1659670584674.png

 

 

@NewNW ,

That code will only work for the Items of the Data Table (not where you have it)- I responded to your question of how to group the collection RequestCollection in the top table shown to result in the table at the bottom.

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

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

Top Kudoed Authors
Users online (1,630)