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."
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.
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,
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Learn from the top Power BI, Power Apps, Power Automate & Power Virtual Agents experts!