Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

How to pull more than 2000 items from SharePoint to powerapps

I have SharePoint list with more than 2000 items and its getting added daily.


unnaturally i will be get only 2k items in powerapps.


Can some suggest me to grab the more than 2K items from Sp to powerapps please.


Pls suggest me example..






You did not follow my suggestion at all.


The SEARCH function cannot be delegated.  This is a limitation of SharePoint. If you must have the SEARCH function then you'll have to switch to another datasource such as SQL or Common Data Sevice but that will not be free.


Instead, you must do this as a workaround for SharePoint (I shared this in my post above already):


1.  Create a new text-box and name it TextInput_PartNumber

2.  Put this code in the Items property of your gallery.

Filter(your_datasource_name, StartsWith(your_partnumber_column, TextInput_PartNumber.Text))

3.  Type in a part number in the TextInput and information will display in the Gallery.


Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."



There is no difference, it's not loading the result more than 2k even after applying the below code.


See the enclosed 3pic.

Hi @sunilkumar ,


If you change to use Filter & StartsWith function, the formula should be delegable, you should be able to get all SharePoint list records.

Note: you can try to set the Delegation threshold from 2000 to 5, it will be easier to see if the formula is delegable.



Hi @sunilkumar 

I don't know if this help, but i use iteration to pulling data more than 2000 records. 

ClearCollect(c_Iter1, ["A*", "B*", "C*", "D*", "E*"]);
ClearCollect(c_Iter2, ["F*", "G*", "H*", "I*", "J*"]);

ForAll(c_Iter1, Collect(c_Data1, Filter(DataSource, ProductNumber = Value));
ForAll(c_Iter2, Collect(c_Data1, Filter(DataSource, ProductNumber = Value));

You can use as much iteration collection as you fit. This is work perfectly for me in many cases.

I hope this help,



Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,510)