I have two SharePoint lists as my data sources. One of the list holds events that have a date column and the other one holds the actual participants referring to those events -> 1:m relationship. Additionally the events list also has a column "MaxCount" denoting how many people can attend the event. In my PowerApp I provide my clients with a gallery where they can choose which event they want to attend to. Now I would like to filter out all event items in the gallery where the "MaxCount" has been reached. I tried something like this:
Where ID is the SharePoint list item ID of the event item I use in the participants list to reference my events. When thinking about it, it could not work, because CountIf does not know about the surrounding Filter call, right? Is there a way I can reference the "outer" ID? Is there another way to achieve my goal? I though of displaying the event and when trying to apply for it I would give out an error, but that is not very user friendly. Thank you for your help.
I created another column "EventID" on my event list. Since you cannot use "ID" field in calculated columns, I currently assign the ID manually. Although this error-prone it is actually quite simple to handle.