web

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

News and Announcements icon

Power Platform CommunityForums Power Apps MDA Create a list that...

Power Apps

Unanswered

MDA Create a list that displays totals for entity records with the same name

(0) Share

Report

Report

Posted on by KST

Hello!

I want to create a list for an entity that shows totals for each record with the same name. Similar to the image below name is left column, right is total. How can I achieve this?

Screen Shot 2022-10-20 at 11.02.07 AM.png

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @KiaThompson ,

The below would give you the fields for the Table shown

AddColumns( GroupBy( ListName, "YourNameField", "Data" ), "MyTotals", CountRows(Data) )

You would then sum them at the bottom in a Label

Sum( GalleryName.AllItems, MyTotals )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No

Join the conversation