Unanswered

Find Item Highest Count and Display That Items Name

(0) Share

Report

Posted on by TONYSTORM

Hello,

I have a gallery that is showing feedback from users. I have a column made for each question and the response is going under each one. I am looking to display the item with the most results. (see pic below) Since "Strongly Agree" is the response with the highest count I would like to display Strongly Agree to users. Thank you so much 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

TONYSTORM 49 on at

Like (0)

Report

Just to clarify. This is a dashboard that is showing the top responses from Users. So basically I will have an area that is titled "Top Responses" and the Response with the highest count will display in this area. I hope this helps.

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report
Hi @TONYSTORM ,

I did a test for you.

1\ This is my table

ClearCollect(Col,{Value:"A"},{Value:"A"},{Value:"B"},{Value:"A"},{Value:"C"},{Value:"C"},{Value:"A"})

2\ Add a label control and set its Text property to:

First(SortByColumns(ForAll(Distinct(Col,Value) As A,{Number:CountIf(Col,Value=A.Result),Vaule:A.Result}),"Number",Descending)).Vaule

3\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
TONYSTORM 49 on at

Like (0)

Report

Thank you! Getting an error. could you break that down for me . Thank you

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @TONYSTORM ,

Could you provide some information?

For example, the items formula of your gallery

It's hard to help you solve the problem without enough information.

Best Regards,

Wearsky

Was this reply helpful? Yes No