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
mdevaney
Super User
Super User

@sunilkumar 

Why do you need to pull ALL of the records into your app at once?  Most times this is not necessary.  Many scenarios have a workaround.

 

Please let me know the specific task you are trying to do that would require all records and we can figure out a different way to do it.

 

Any of these functions and data types will work with over 2,000 records.

 

Capture.PNG

 

 

---
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."

8BitWarrior
Advocate III
Advocate III

@sunilkumar 

There is a way to bring more items into PowerApps, I had to do this for one of my application. You will need to use Collections in order to do this. The logic is simple, you need to create a series of smaller collections and then Collect them into collection to combine all the record.

//Divide your Data Source into smaller collection based on some value

ClearCollect(Collection1,Filter(DataSource,Condition));
ClearCollect(Collection2,Filter(DataSource,Condition));
ClearCollect(Collection3,Filter(DataSource,Condition));
ClearCollect(Collection4,Filter(DataSource,Condition));
ClearCollect(Collection5,Filter(DataSource,Condition));

//Note that when filtering your collections, your filters must not bring in more than 2000 records

//Combine your collections into one
ClearCollect(AllCollections,Collection1,Collection2,Collection3,Collection4,Collection5);




actually i have gallery in power apps, in this we use to search by part number to know the status,  are we inspected same part or not before going to start the inspection every time.

 

When i am searching to know the status it should search overall SP items list and provide me the final result.

 

So i have to pull all the items into power apps.

@sunilkumar 

To filter a gallery by part number you can do this:

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."

since, i have only one SharePoint list with more than 2k items with Part number, Part description, Request ID, etc.

 

Can you please explain bit more based on given above example please;

 

Thanks

Sunil

@sunilkumar 

Suggest you try my idea and let me know the result.  This works on SharePoint lists with over 2k records.


---
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."

it is not working code, it is just filtering only 2k items but out of 2k it;s not showing the result.

@sunilkumar 

Please share a screenshot showing what you have input into the formula bar for the Items property of the gallery.

see the attachment please 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

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

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 (2,959)