cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Users online (6,329)