Power Apps introduced a ThisRecord property which allows you to refer to an entire record of the collection rather than an individual field. This can be used to remove duplicate rows from a collection with one line of code.
To remove duplicate records from your collection use the following code:
ClearCollect(
colUnique,
ForAll(
Distinct(colDuplicateRows,ThisRecord),
ThisRecord.Result
)
)