web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Merge similar gallery ...

Power Apps

Unanswered

Merge similar gallery rows into 1 row.

(0) Share

Report

Report

Posted on by Iantaylor2050

603

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

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No

Join the conversation