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.