Group by in power app Gallery to unique values

[ST3]

Hello All,

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

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

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.

[v-bofeng-msft · Accepted solution]

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

[ST3]

Thank you . It worked