cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dudditz
Responsive Resident
Responsive Resident

Create Collection filtering all ID's from existing collection against ID in SharePoint List.

 

Hello, in the following formula my goal is to create a new collection named Votes_COL3 that will be populated with all records from the outcome of filtering the MeetingID column within the SharePoint List Meeting-Votes against Topics_COL.ID which is also a SharePoint ID column in a collection.  Basically the goal is to fill the new collection with all records that match every ID from Topics_COL.ID  While this formula seems to work I am dealing with the delegation warning and not filtering is a problem as this list is massive.  I feel like there must be a way around this using a different approach.  Any guidance would be appreciated.

 

ClearCollect(
Votes_COL3,
ShowColumns(Filter('Meeting-Votes', MeetingID in Topics_COL.ID),
"MeetingID",
"Vote",
"Employee",
"Title"
))

2 REPLIES 2
leyburn19
Memorable Member
Memorable Member

The delegation is based on using the 'in' filter.  If everything is under the 2000 extended limit then it is not a problem.  If it is over the 2000 than it is plus you have other issues as a Collection is restricted to 2000 records at any time unless you connect them together

 

I assume you are using the in as the ID sits with the text in Topics_COL.ID and it is with other text?

 

 

Dudditz
Responsive Resident
Responsive Resident

Yep, I meetingID and ID are one of the same just in separate lists as MeetingID is populated with ID further upstream in the PowerApp.

 

Meeting-Votes' is the problem as its going to get quite large and I have no need to return all the values however only the values that match the ID from the collection Topics_COL

 

I understand the 2000 record limit and it will get larger.  I am open to other methods however not sure if there is a way to match a bunch of records in one data set against another without delegation issues.

 

 

 

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (20,708)