Answered

Max values from collection

(0) Share

Report

Posted on by Kepcla

Hi experts!

I have a source with this items :

And I want to create a collection only with maximum values (red values) , I try with "AddColumns", but it gives me the max for every row...maybe using "group by"...but I don´t know how!

it should be like this:

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

eccountable_dev 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Im just starting but my initial thoughts are to use the max of every record as a comparative to create a different collection that only shows the data like in your second picture. I figure you could use a button, on change event or anything of the sort to check and collect.

again I'm still pretty new at this but that is how I might go around the problem you are having. Someone probably has a more efficient and clearer answer then myself.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
HI @Kepcla,

Please create this collection as below:

DropColumns(AddColumns(GroupBy(colG,"Site","Type","SG"),"Max",Max(SG,To)),"SG")

Was this reply helpful? Yes No
Kepcla on at

Like
a
(0)

Report
Copy link

Link copied!

I tried with GroupBy and AddColumns, but your solution @v-qiaqi-msft is more practical and fast.

Was this reply helpful? Yes No