Hi all,
any one please suggest the formula to filter the first id iof Each group after applying the Group by.
Source Table:
Id , Value
101,AST
106,AST
114,AST
126,Bottle
129,Bottle,
130,Nike,
142,Nike
Filter Table Should be:
101,AST
126,Bottle
130,Nike
Please proivide any solution to achieve this.
Hello,
I think that it can be improved but the following expression can solve your issue..
Gallery1.Items = ForAll(Distinct(A,Value),LookUp(A,Id=Min(Filter(A,Value=Result),Id)))
Here is a suggestion that only requires reading the source table once:
AddColumns( GroupBy( SourceTable, "Value", "AllRows" ), "MinId", Min(AllRows, Id) )
The result will contain the AllRows column, but this can be ignored.
I think Meneghino's solution is better. You should use that one.
You can use the DropColumns() function to get rid of the AllRows column if you want to.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
184 | |
53 | |
41 | |
36 | |
30 |
User | Count |
---|---|
240 | |
74 | |
71 | |
69 | |
65 |