Unanswered

How do I remove duplicate rows with 2 columns in a collection

(0) Share

Report

Posted on by Anonmyous123

In my Gallery, I only shows Title of books, but in the backend information, it has several variables like BookID, Publisher, BookTitle and etc... All the variables are in a collection called colDistinct.

The question is how can I show Title of books with no duplicate value (distinct BookID and BookTitle)?
I want to remove duplicates BookID and BookTitle and display the final result in the Gallery.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report
Hi @Anonmyous123 ,

You could use GroupBy, but you will need to "add back" any columns not in BookID or BookTitle

AddColumns( GroupBy( DataSource, "BookID", "BookTitle", "Data" ), "Column1Name", First(Data).Column1Name, "Column2Name", First(Data).Column2Name )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Jonathan Manrique 2,687 on at

Like (0)

Report
Hi @Anonmyous123

Hello, can you try this formula?

ClearCollect( UniqueCollection, RemoveIf( DuplicatesCollection, CountRows( Filter( DuplicatesCollection, Column1 = ThisRecord.Column1 && Column2 = ThisRecord.Column2 ) ) > 1 ) )

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution

Was this reply helpful? Yes No
Anonmyous123 13 on at

Like (0)

Report

I am not sure how applies in this case. Would you mind simplifying this explanation for me? I'm still new to Power Apps and want to make sure I fully understand. Thank you in advance.

Was this reply helpful? Yes No
Anonmyous123 13 on at

Like (0)

Report

I've tried this formula but it is not work.

Was this reply helpful? Yes No
WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report

@Anonmyous123 ,

GroupBy() eliminates duplicates, but only returns the grouped column/s and a Table containing the rest of the grouped records. The code I supplied then shows how to re-include these. Please have an attempt at it and I am happy to correct if required.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No