Answered

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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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))))

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you! This worked great!

Was this reply helpful? Yes No