How to show Unique Item?

[biha]

I have a few sheets in Service App.

Fleet Page:

ID |

EB1
EB2
EB3
EB4

Inspection Report Page:

Report No | Eq ID

PM-B-001 | EB2
PM-B-002 | EB2
PM-B-003 | EB4

Part Replaced Page:

Date | Report No | Part Replaced | Array(Lookup after SelfRelation ReportNo)

2/9/2023 | PM-B-002 | Engine Oil | Engine Oil, Battery, Filter
2/9/2023 | PM-B-002 | Battery | Engine Oil, Battery, Filter
2/9/2023 | PM-B-002 | Filter | Engine Oil, Battery, Filter
4/9/2023 | PM-B-004 | Filter | Filter, Fuel Filter
4/9/2023 | PM-B-004 | Fuel Filter | Filter, Fuel Filter
9/9/2023 | PM-B-001 | Tyre | Tyre, Hyd Oil
9/9/2023 | PM-B-001 | Hyd Oil | Tyre, Hyd Oil

My question is

How to show the list group:

EB1

2/9/2023
PM-B-002
Engine Oil, Battery, Filter

9/9/2023
PM-B-001
Tyre, Hyd Oil

I manage to do something like this:

EB1

2/9/2023
PM-B-002
Engine Oil, Battery, Filter

2/9/2023
PM-B-002
Engine Oil, Battery, Filter

2/9/2023
PM-B-002
Engine Oil, Battery, Filter

9/9/2023
PM-B-001
Tyre, Hyd Oil

9/9/2023
PM-B-001
Tyre, Hyd Oil

Its repeating the same row in Part Replaced Page.
Do you guys have any ideas on how to filter only unique element?

This is a sample the list based on the Part Replaced Page.
Suppose showing 2 items.
but the PM-B-0316 is showing 2 because the entry was 2. 1 is battery and another is Engine Oil filter.

[Darren_Murphy]

• Add a RowID column
• Create a self-relation (multiple) that matches the Report Number with itself (I think you already have this?)
• Add a Single Value column that fetches the first RowID from the relation
• Add a filter to your collection: RowID is Single Value RowID

[biha]

Heheheheh thanks darren