Aug 1, 2022 8:51 PM

Remove Duplicate Rows From A Power Apps Collection

External YouTube Channel

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

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.

  • Remove Duplicate Rows From A Power Apps Collection

https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-distinct

  • ThisItem, ThisRecord, and As operators

https://docs.microsoft.com/en-us/power-platform/power-fx/reference/operators#thisitem-thisrecord-and-as-operators