web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Agroup a gallery based...

Power Apps

Answered

Agroup a gallery based on a column value

(0) Share

Report

Report

Posted on by Igarsaba

37

Hi guys, everything ok?

I need some help to build a Gallery:

I have a Sharepoint List with the Title column based on a requisition number
When i send a info, PowerApps fill that column with the HE number (HE0001, HEQ0002), etc:

When i put this Sharepoint List as my DataSource, he display the items with this order:

I want to agroup the records based on Requisition number, basically i need to display HE0001 infos only one time.

Is that possible?

With that possibility, i want to collect the Title (HE0001) to display a table below with all infos send on that requisition number and be aple to patch then to "Approved" status.

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Igarsaba

Grouping is not a problem, but your data has different information for each row of the group (the matricula column)

Since you don't seem to be displaying that, you can ignore it, but if there are other columns with different values, then you need to determine how you will handle different records in your group.

Otherwise, your Items property for the Gallery can be:

ForAll( GroupBy( 'Horas Extras', "Titulo", "_items" ), Patch({Titulo: Titulo}, First(_items)) )

I hope this is helpful for you.

Join the conversation