cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Count and compare data in CDS, that meets a specific condition in PowerApps

I know that in PowerApps you can use the LookUp function to find the data in CDS that meets a specific condition. Is there a function, either in PowerApps or a setting in CDS, that can count all the data/forms that meet a specific condition? 

I have two CDS entities: one that stores information for upcoming events and one that stores the information for individuals who have registered for an event (all submitted as forms). I currently have a field in the upcoming events entity that stores the maximum number of attendees for that event. I would like to implement a method in PowerApps/CDS that can count the nubmer of individuals who have registered for a specific event, and compare it to the maximum number of attendees field, set for that specific event in the upcoming events entity. If the maximum number of attendees field for that event is equivalent to the number of people who have registered for that event, I will complete a specific action in PowerApps. 

 

Any ideas? Thank you very much 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Count and compare data in CDS, that meets a specific condition in PowerApps

Wrap countrows() around the filter() function for your collection and display the result in a label. For example
Countrows(Filter(Event,registered="attending"))

View solution in original post

1 REPLY 1
Highlighted
Super User
Super User

Re: Count and compare data in CDS, that meets a specific condition in PowerApps

Wrap countrows() around the filter() function for your collection and display the result in a label. For example
Countrows(Filter(Event,registered="attending"))

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (6,907)