web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Finding most common value

Power Apps

Unanswered

Finding most common value

(0) Share

Report

Report

Posted on by Gwill1983

271

Hi.

I am trying to identify the most common value in an excel column and return this into a text label in my app.

It feels like this should be straightforward, but I am struggling a little bit.

the table name is ‘predictions’ and column name is ‘CountryName’.

Is anybody able to help? I have read several blogs on this, but just cannot make anythinv work!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

anandm08 1,936 Super User 2024 Season 2 on at

Like (1)

Report
hi @Gwill1983 ,
you can use something like this formula and put this in the Text property of the label:
First(SortByColumns( AddColumns( GroupBy(predictions, "CountryName", "Grouped"), 'Count', CountRows(Grouped) ), "Count", Descending )).CountryName

Let me know if my answer helped solving your issue.
If it did please accept as solution and give it a thumbs up so we can help others in the community.

Was this reply helpful? Yes No
Gwill1983 271 on at

Like (0)

Report

Thanks. That is returning a fair few errors (8). It seems ok until I enter the CountRows(Grouped) part, but it doesn’t recognise Grouped as anything.

Was this reply helpful? Yes No
Shravyashree_01 174 Moderator on at

Like (0)

Report
Hi @Gwill1983 , Please use the below clearcollect OnStart or OnVisible of the screen
ClearCollect(colPredictionValue, Sort(AddColumns(GroupBy(predictions,CountryName,NewGroup),CountRows,CountRows(NewGroup)),CountRows,SortOrder.Descending));
Now, for the TextLabel use the below code

First(colPredictionValue).CountryName
Let me know if it solves the issue !

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.

Was this reply helpful? Yes No

Join the conversation