Power Apps Tip: Remove Duplicate Rows From A Collection (Works Every Time)

Remove the duplicate rows from any Power Apps collection with this 1 line of code.

Here's how it works: the Distinct function returns a one-column table of unique values for a field. But when we use ThisRecord instead of a column name it results in a one-column table of unique records. Then we loop over the one column table using ForAll to extract the rows into a multliple column table.

[qzll]

Straight to the point. I like it. Thanks man!

[gregcalvert]

Been following your blogs since I started with PowerApps. Glad to see you have a YouTube channel.

[alfonsolans]

Great Thanks for the information Matt Awesome as always appreciate your support

[caileighabente]

Awesome! Worked like a charm, thanks!

[matthewdevaney]

How did 2 people like this video within seconds of me posting it? You are both amazing!

[vishaljhaveri]

Thank you Sir. Nice video and explanation.

[AssassinUK]

My gosh, how come you have had a channel for years and I only just found you by accident. I'm on your site at least 2 or 3 times a month!

[buddhidayawansa]

I have duplicate identifier colomun in Sharepoint list. May I know how can I use this column to eliminate duplicates?

[christianfernandotorricomo]

hello matthew your video helped me a lot, I would like to know how to eliminate duplicate records that contain 2016 in the year column

[MrKhulaid]

Thank you for this. Does it show the most recent record? Or should I wrap this is a sort?

[huyfe]

Thank you. Can you tell me why data from calculated fields in a table collection are not being patching in a sharepoint list?

[Nk-oscj]

Can you help me
I recently create a collection in which I can store the data from the drop-down selected item and count data entered by the user when I hit the add button it should add the respective data to the collection and that collection data is represented in the gallery. I want to represent such that if the data is already present in the data then there should be a single row where all the data is visible and count of both existing and newly formed data is added up and shown

[Shawdow]

Use 'Value' instead of 'Result' . Powerapps terminology change

(as of August 2023)

[DataisKing]

I'm trying to remove duplicates from a SharePoint list. Any ideas?

[csgexec]

Unfortunately, this does NOT work every time. In fact, it doesn't seem to work at all. For my purpose, I want the collection itself to only include distinct records, which this does not address. But even using it for the Items definition of a combo-box does not work. The errors returned are ForAll has invalid arguments - and "Result" isn't recognized. Any other ideas?

[TheTeslaTess]

How can I save the duplicate free collection to the table