cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sunilkumar
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..

 

Thanks 

Sunil

13 REPLIES 13

@sunilkumar 

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.

Sik

 

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,

 

Regrads,
pytbyt

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (1,641)