web

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

News and Announcements icon

Power Platform CommunityForums Power Apps GroupBY in Gallery

Power Apps

Answered

GroupBY in Gallery

(0) Share

Report

Report

Posted on by PapithaSekar1

100

Can we use GroupBy function to Group the Gallery data?

For example:

I have a gallery contain records, list of used medicine and medicine type, I want to groupby according to medicine type and find the total no of used medicine for all medicine type.

I can able to find total no used medicine according to medicine type on label by using the below formula
Sum(Filter(Gal_RoomPlan.AllItems,DD_Vactype.Selected.Value = "Pfizer"),Value(Usedvac.Text)),
But i want to find all available medicine without hard coding the Medicine type value and display it in gallery .

How can i achieve this.Anyone have any idea?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PapithaSekar1 ,

This will get you two columns - Medicine Type (you may have to correct the field name) and TotalUsed which will be the total of each.

AddColumns( GroupBy( Gal_RoomPlan.AllItems, "MedicineType", "OtherData" ), "TotalUsed", CountRows(OtherData) )

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