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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,490)