Power Platform Community Forum Thread Details

I have a powerapp gallery with SharePoint as the backend.

There are multiple rows which has the same Serial number. I want to merge the last column and show info icon only once, instead of displaying 5 times. Any idea how to merge gallery rows into one row?

Screenshot included below. The last column should get merged into one as all belongs to same serial number DC202303-3.

Any idea how to achieve this?

Categories:

Building Power Apps

Hi @Iantaylor2050 ,

If I were to "draw" what I think your trying to do in Excel, I think the expected output would be this:

If this assumption is correct, then in the Items property of the Gallery, enter:

AddColumns(
 'Your Data,
 "isFirst",
 !IsBlank(
 LookUp(
 ForAll(
 GroupBy(
 'Your Data',
 "Your Serial Number Field",
 "_GroupedItems"
 ),
 {
 _firstID: First(ThisRecord._GroupedItems).ID,//SharePoint ID
 _serialNumber: ThisRecord.'Your Serial Number Field'
 }
 ),
 _firstID = ID,//SharePoint ID
 _firstID
 )
 )
)

In the Visible property of the Icon in the Gallery, enter:

Boolean(ThisItem.isFirst)

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

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan