I have a sheet with listings. There are a lot of duplicates which is intentional because the same item may have been listed many times. However, when I show them in a collection, I don’t want to show all the duplicates. When someone selects and item, it takes them to graph and shows the item’s pr…

Try creating a single relation from the main column of the items (Row ID or Name) to the same column. It’s important that you uncheck ‘Multiple’. Then display that relation as the source of the collection. EDIT: This answer is incorrect. See Thinh’s correct approach below. [image] …

Creating a single relation from the item’s rowID to itself. Create a lookup to retrieve the rowID from the relation. That will be the first ID among all duplicates. Filter your collection by rowID equals “first ID”.

This worked perfectly. Thank you!

Remove duplicates

Ask for Help

ThinhDinh November 30, 2023, 11:25pm 3

Creating a single relation from the item’s rowID to itself.
Create a lookup to retrieve the rowID from the relation. That will be the first ID among all duplicates.
Filter your collection by rowID equals “first ID”.

Topic		Replies	Views
How to Remove duplicated locations from a collection list Ask for Help	8	45	April 3, 2025
Filter to display DISTINCT (or Unique) rows based on specified columns Feature Requests	7	3792	June 18, 2024
How do I prevent duplicate items from appearing in the collection component? Ask for Help	3	358	February 9, 2023
How to show Unique Item? Ask for Help	3	183	October 11, 2023
Removing duplicate Items Ask for Help	4	632	May 19, 2022

Remove duplicates

Related topics