Distinct filter item

[SumanthDundi7]

Hi,

I am using SharePoint list with PowerApps with Parent Gallery and Child Gallery to show items as in the screenshot below. 

Items property of the ParentGallery is set to Distinct('Amazon Audit',Region)

Items property of the ChildGallery is set to Filter('Amazon Audit',Region=ThisItem.Result)

Output of my above logics are as in the screenshot. 

I would also like to avoid duplicates of Locker IDs. Please help me on how can I achieve this.

[Drrickryp · Accepted solution]

@SumanthDundi7 

I suggest using GroupBy('Amazon Audit',"Region", "DATA") as the Items for the outer gallery.

For the subgallery Items property: Sort(Distinct(ThisItem.DATA,LockerID),Result)

and for the individual labels in the subgallery:

• ThisItem.Result, (which would show the LockerID)
• LookUp('Amazon Audit',Result=LockerID, Visits) and
• LookUp('Amazon Audit',Result=LockerID, Market) 

An alternative without using GroupBy() would be to set your subgallery items property to 

Distinct(Filter('Amazon Audit',Region=ThisItem.Result),LockerID) and the individual labels would be the same as above.

[SumanthDundi7 · Accepted solution]

Thank you so much @Drrickryp .