cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ST3
Frequent Visitor

Group by in power app Gallery to unique values

Hello All,

I am building Power app , where I have to show unique records in gallery. For example -

ST3_0-1664504475484.png

if this is database , then User should only see result as 

ST3_1-1664504599970.png

User should only unique records but not how much quantity? I created unique value 'XX' for each distinct row, used Group by on XX . However Gallery Overrides duplicated record two times on same row. I, short , group by did not resolved issue.

Please guide and Help.

 

Thank you in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @ST3 ,

 

Is xx the column that holds the group names?

 

If so, you could try this formula:

 

ForAll(

   Distinct(TheTable,XX).Result,

   LookUp(TheTable,XX=Result)

)

 

Best Regards,

Bof

View solution in original post

2 REPLIES 2
v-bofeng-msft
Community Support
Community Support

Hi @ST3 ,

 

Is xx the column that holds the group names?

 

If so, you could try this formula:

 

ForAll(

   Distinct(TheTable,XX).Result,

   LookUp(TheTable,XX=Result)

)

 

Best Regards,

Bof

Thank you . It worked 

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,902)