How to filter a gallery based of the count of another list

[Becca51178]

SPList1 = Event List

SPList2 = Signup form for event list

Here is the process. SPList1 has all the events available for sign up and it has a column called Volunteers Needed which is the number of people needed for each event

SPList 2 is the signup sheet. 

I need to be able to filter out an event in a gallery when the count of signees for an event on SPList2 equals the number of volunteers needed on SPList1

The filter code below doesn't work. Do I need to create a second collection instead?

Any help would be awesome

Filter(SPList1,
         EventType="Project",
        EventSupportSearchDate<=Today(),
       SupportStaffNeeded= true,
       EventSupportSearchDate<=Today(),
      LastDaytoRegister>=Today(),
     Not(EventName in UserSignUpList.EventName),
    EventLeader.DisplayName<>Var_OfficeName,
   EventName && VolunteersNeeded=(CountRows(Filter(SPList2, EventName))))

[Anonymous · Accepted solution]

You can use this to build on to your event list. This would replace the general SPList1 reference in your filter.

AddColumns(SPList1,"EventFull",CountRows(Filter(SPLst2,EventID=[@EventID]))>=NumberOfSupportStaffNeeded)

 Here is the docs for AddColumns()

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-table-shaping

---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.

[Becca51178]

Thank you! This worked great!