web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Returning records with...

Power Apps

Answered

Returning records with a unique set of values on specific columns

(0) Share

Report

Report

Posted on by benyie

31

Hi!

I have a collection looking like the one below.

I want to return the records with a unique set of ClientSplitId and InsuranceTypeId,

which in this case is the combos (3,1) (3,2) (3,3) and (3,4) so I would only get 4 records remaining.

Any help would be thankful!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

timl 37,212 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@benyie

The GroupBy function will carry out this task.

GroupBy(YourCollection, "ClientSplitId", "InsuranceTypeId", "RemainingColumns" )

This formula will return a table with 4 rows and 3 columns. The column "RemainingColumns" will contain a nested table that contains the grouped values.

Was this reply helpful? Yes No
benyie 31 on at

Like (0)

Report
Copy link

Link copied!

@timl Thank you for help!
I was a bit unclear though, I still want all the 4 original columns but only records containing the set of unique values from ClientSplitId and InsuranceTypeId combined. This would result in 4 rows and 4 columns. Which 4 records I choose from the original table is not of importance.

Was this reply helpful? Yes No
Verified answer

timl 37,212 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@benyie

If you want the output to include the first row that matches the unique combination, this is the formula you would use:

AddColumns( GroupBy(YourCollection, "ClientSplitId", "InsuranceTypeId", "RemainingColumns" ), "InsuranceTypeSplitID", First(RemainingColumns).InsuranceTypeSplitID, "RemovedSplit", First(RemainingColumns).RemovedSplit )

Was this reply helpful? Yes No
benyie 31 on at

Like (0)

Report
Copy link

Link copied!

@timl Thanks!

Was this reply helpful? Yes No

Join the conversation