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 III
Super User III

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 III
Super User III

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Users online (11,590)