Answered

Add one more column to a group

(0) Share

Report

Posted on by Merida

Hello, i think that this question is simple, but i can't think a properly way.

Sort(
 AddColumns(
 GroupBy(
 MeioBombeadoCollection1;
 "MEIO (DADO TRATADO)";
 "mostOften"
 );
 "total";
 CountRows(mostOften)
 );
 total;
 Descending
 )

in this code, my sort only results in two collums, the one with "total" and "MEIO (DADO TRATADO").

I wanna insert another one from the main collection "MeioBombeadoCollection", how can i bring together this in sorting?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Merida ,

I assume you only want to Sort by the column ?

SortbyColumns( AddColumns( GroupBy( MeioBombeadoCollection1; "MEIO (DADO TRATADO)"; "mostOften" ); "total"; CountRows(mostOften); "MeioBombeado"; First(mostOften).MeioBombeadoCollection ); "MeioBombeado"; Ascending; "total"; Descending )

If you want to GroupBy with it as well

SortbyColumns( AddColumns( GroupBy( MeioBombeadoCollection1; "MEIO (DADO TRATADO)"; "MeioBombeadoCollection"; "mostOften" ); "total"; CountRows(mostOften); ); "MeioBombeadoCollection"; Ascending; "total"; Descending )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Merida 62 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes @WarrenBelz, this worked with a few alterations in my case, that was the exactly function needed, thanks!

Was this reply helpful? Yes No