Answered

How can I calculate the max value in a collection table?

(0) Share

Report

Posted on by esilvac

Hi everyone, I created a table collection on Power Apps. The table has the column named "NType", "ID" which stores numbers, with those numbers I can locate records in another SharePointList, "Email" which stores the email of the persons who create the record and column "Votes" which counts the number of votes left for the specific record. A person can leave more than 1 vote for a record. On my Power Apps based on this table, I would like to obtain Informations such as the ID with the most votes (I belive I would need to count these) and to know as well the ID's with the most votes for the diferents NType "S, "T" and "A". How can I display such results?

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

v-hanytian-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @esilvac ,

We made a sample for you.
Max ID:
"MaxID:" & LookUp(Col,Max(Col,Votes) = Votes,ID)
"MaxID-T:" & LookUp(AddColumns(GroupBy(Col,"NType","NTypeGroup"),"MaxVote",Max(NTypeGroup,Votes),"MaxID",LookUp(NTypeGroup,Max(NTypeGroup,Votes) = Votes,ID)),NType = "T",MaxID)
Hope this will help you,
Best Regards,
Tina
esilvac on at

Like
a
(1)

Report
Copy link

Link copied!

hello, thank you so much! This helped me a lot! 🙂