Answered

How to group by, then take first line of a group

(0) Share

Report

Posted on by martinav

3,347

I have a list of indexes in this data. I want to group by WOxxx, then take the first (lowest index number) and only show that line in the result. I feel like I'm close with this, but not yet.

ClearCollect(SN_Test_DF_Filtered,
 First(GroupBy(
 SortByColumns(
 Filter(SN_Test_DF_Idx, CompanySearch.Text in Company And 
 TypeSearch.Text in ValveType),
 "SN",Ascending),
 "WONum","SN2")))

SN ValveType Company WONum

So, I want this set reduced to these three lines.

35019.....

44372....

58589....

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

CU-18081211-6 9,272 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@martinav ,

Can you try this approach:

ClearCollect(SN_Test_DF_Filtered, DropColumns( AddColumns( GroupBy( Filter(SN_Test_DF_Idx, CompanySearch.Text in Company And TypeSearch.Text in ValveType), "WONum","SN2"), "Result", First(Sort(SN2,SN,Ascending)).SN, "WONum","SN2") )

The result should be a one column collection called by me "Result".

Hope it helps !

Was this reply helpful? Yes No
Verified answer

Ashwin7104 671 on at

Like
a
(1)

Report
Copy link

Link copied!
Hey @martinav ,

Try below code and let know if it works for you
ClearCollect( SN_Test_DF_Filtered, ForAll( GroupBy(SortByColumns(Filter(SN_Test_DF_Idx, CompanySearch.Text in Company And TypeSearch.Text in ValveType),"SN",Ascending),"WONum","SN2"), { SN: First(ThisRecord.SN2).SN, WONum: ThisRecord.WONum } ) )

Was this reply helpful? Yes No
martinav 3,347 on at

Like
a
(0)

Report
Copy link

Link copied!

Seems I got some great help from two at once!!! @Ashwin7104 , yours worked right out of the box. Its also nice and tidy on how to get the rest of my columns in the result.

@gabibalaban , I think what you provided would produce the same result. However, something was broken, and I couldnt figure out what the issue was. I'm not smart enough!! So, I used @Ashwin7104 's solution this time.

Thank you both for your help!!!

Rod

Was this reply helpful? Yes No