Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Batch Load SharePoint List (~6000) into Collection

I have been looking for some solutions to batch load my SharePoint list into a collection so I can use some of the search features that do not delegate. I found one example but "<" does not delegate so now I'm stuck. What is everyone doing to accomplish this task?


This is loading directly from SharePoint to the PowerApp. No CDS.




Super User
Super User

Re: Batch Load SharePoint List (~6000) into Collection

After doing some looking into delegation with SharePoint, I am not too sure how it would work. (I have the joy of working in Azure SQL, which seems to be the easiest scenario.) Is there a way to collect filtered sections that could make up the whole?

Maybe you could share some of the structure of the data to help work out a method. Only having = and no inequalities to work with will be tough but probably (hopefully!) not impossible. And hopefully someone with more SharePoint experience will chime in too.
Community Support Team
Community Support Team

Re: Batch Load SharePoint List (~6000) into Collection

Hi @maverick17,


Please share your formula here. According to, within the Filter and LookUp functions, you can use these with columns of the table to select the appropriate records:








Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Level: Powered On

Re: Batch Load SharePoint List (~6000) into Collection

@v-monli-msft - not with SharePoint....


2018-10-10 08_14_36-Delegable data sources in canvas apps - PowerApps _ Microsoft Docs.png

Helpful resources


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 102 members 5,500 guests
Please welcome our newest community members: