web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to pull more than ...
Power Apps
Unanswered

How to pull more than 2000 items from SharePoint to powerapps

(0) ShareShare
ReportReport
Posted on by 62

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

Categories:
I have the same question (0)
  • mdevaney Profile Picture
    29,989 Moderator on at

    @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 Profile Picture
    68 on at

    @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);
    




  • sunilkumar Profile Picture
    62 on at

    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.

  • mdevaney Profile Picture
    29,989 Moderator on at

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

  • sunilkumar Profile Picture
    62 on at

    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

  • mdevaney Profile Picture
    29,989 Moderator on at

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

  • sunilkumar Profile Picture
    62 on at

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

  • mdevaney Profile Picture
    29,989 Moderator on at

    @sunilkumar 

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

  • sunilkumar Profile Picture
    62 on at

    see the attachment please 

  • mdevaney Profile Picture
    29,989 Moderator on at

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

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 765 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 272

Last 30 days Overall leaderboard