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))))
Solved! Go to 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.
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.
Thank you! This worked great!
User | Count |
---|---|
260 | |
109 | |
92 | |
56 | |
41 |