Showing results for 
Search instead for 
Did you mean: 
Kudo Kingpin
Kudo Kingpin

How does Filters work with SharePoint Connectors



I was speaking at SharePoint Saturday Leicester today and we got into a discussion on how does the SharePoint Connector work when you use a statement in PowerApps like ClearCollect(myCollection,Filter(sharepointlist, sitecolumn1 = "MyText").#


Does it

1) only bring say 35 rows back from the SharePoint list even though there may be 20,000 rows in the list. (ie the query is done at the SharePoint list.

2) attempts to bring back 20,000 rows into PowerApps, can only bring 2000 rows as that is the max PowerApps can bring back and then tries and filter on the 2,000 rows it actually brought back into PowerApps.





Resident Rockstar
Resident Rockstar



The = parameter is delegatable to SharePoint (See docs for delegation info), so 1 is probably a yes. As soon you try to do this with a parameter which is not delegatable 2 is a Yes.


In general what I do when I add a gallery and want to filter the items I split it up in delegatable and non-delegatable filters. Then I do like this:

  • On the delegatable filters search box I only tricker a toggle on the OnChange attribute.
    On this Toggle.Change I do a ClearCollect from my datasource with only the delagatable filters.
  • The Collection I have in the items off my gallery
  • The non-delegatable filters I add there.

To make this work I add a flat number field to my SharePoint list for each related complex Field. I write the ID from the related list to this number field, as well as the record to the related complex field. This means I always can filter on this ID number field if I want and don't have to worry about the delegation limitations.


Oke you are still limited to 2000 records, but I figure no way that more then 2000 records are relevant on any given time. Off course when you want to sum() numbers it can be a problem, but with that amount off records needed you should not be in SharePoint, but move to SQL Server in my opinion. 


By the way it's correct that you can bring max 2000 records in directly from PowerApps. But you could increase this to 5.000 records if you need when you use Flow as an interface between PowerApps and your Sharepoint List. 


Hope this helps.



Helpful resources

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


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 (8,401)