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))))
Go to Solution.
You can use this to build on to your event list. This would replace the general SPList1 reference in your filter.
Here is the docs for AddColumns()
---If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.
View solution in original post
Thank you! This worked great!
Keep your eyes open for our upcoming T-shirt design contest!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020