Unanswered

Display based on most data count in list

(0) Share

Report

Posted on by nayem

Hi, my list have Category column, which are cleaning, security, plumbing, others, air conditioning, electrical, mechanical.

my plan is to display these category (name only not the data with the category), in a gallery or anything that can arrange them based on data count in the list, I want to make it like leaderboard of Top5 or Top 3 most category data count in the list.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Geeks_D 1,169 on at

Like
a
(0)

Report
Copy link

Link copied!

Check out the distinct and Count functions

The Gallery data source will be Distinct (Datasource, "Items u want distinct") and the label inside the Gallery will be (Thisitem.Value & Count the items)

Was this reply helpful? Yes No
nayem 75 on at

Like
a
(0)

Report
Copy link

Link copied!

can you help me with the count codes? that part make me stuck

Was this reply helpful? Yes No
Geeks_D 1,169 on at

Like
a
(0)

Report
Copy link

Link copied!

CountIf(Datasource, Item = ThisItem.Value)

Accept the Solution if this helps solve your request

Was this reply helpful? Yes No
nayem 75 on at

Like
a
(0)

Report
Copy link

Link copied!

it work, somehow do you know how to solve my initial problem, which is to display them based on the count if, if most it stay first in the gallery item

Was this reply helpful? Yes No
Geeks_D 1,169 on at

Like
a
(0)

Report
Copy link

Link copied!

You will need the SortBy function
Sort( Table, Formula [, SortOrder ] )

Sort(YourDistinctFunction , CountFormular)

Was this reply helpful? Yes No