cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shinn
Frequent Visitor

Count occurence of items in another table

Hi all,

 

I have created a gallery with 2 items and another table with 5 items and i want to count the number of occurrence  in the table based on the gallery items. I have tried using ForAll function and Collection but wasn't able to achieve my desired results.

 

An example is given below.

 

Gallery

User
Alan
Mary

 

Table

User
Alan
Alan
Mary
Mary
Mary

 

Results:

UserCount
Alan2
Mary3

 

Greatly appreciate any help/advise.

 

Best Regards,

Shin

1 ACCEPTED SOLUTION

Accepted Solutions
Ramole
Super User
Super User

Hi @Shinn 

Have look this post please it has the answer 
https://powerusers.microsoft.com/t5/Building-Power-Apps/Count-items-in-list-grouped-by-a-column/m-p/...


Thank you
If this post helps, then Click on the Thumbs Up below. and Accept it as the solution . to help others find helpful.

View solution in original post

1 REPLY 1
Ramole
Super User
Super User

Hi @Shinn 

Have look this post please it has the answer 
https://powerusers.microsoft.com/t5/Building-Power-Apps/Count-items-in-list-grouped-by-a-column/m-p/...


Thank you
If this post helps, then Click on the Thumbs Up below. and Accept it as the solution . to help others find helpful.

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Solution Authors
Top Kudoed Authors
Users online (2,436)