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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Data Retrieval Error U...
Power Apps
Answered

Data Retrieval Error Using Collection

(0) ShareShare
ReportReport
Posted on by 5,331 Moderator

I have an app.

I am going through the items identified in the AppChecker.

I am getting the following warning, twice, on two different collections at AppStart.

How do I best remedy these data retrieval issues?

  'The rows retrieved from the data source may not be completed'.
     Limit the data collected from the data source by updating the formula
     "ClearCollect(Client_Collection,Client_List)" to include a filtering function,
     such as 'Filter' or 'Search'.

Categories:
I have the same question (0)
  • Verified answer
    Michael E. Gernaey Profile Picture
    53,968 Moderator on at

    How are you populating Client_List? Are you doing anything concurrently? Since you are using the AppStart itself, where does Client_List get its data?

     

    Warnings do not always mean there is an issue, just that possibly there will be one. One question I have is why copy between the two versus leveraging just one list? I am sure you have a good reason, just checking since you are duplicating the data.

     

    Is Client_Collection already defined (initialized with data and a structure?), Do the 2 match perfectly in format?

     

     

  • Verified answer
    LaurensM Profile Picture
    12,516 Moderator on at

    Hi @Phineas,

     

    Using a Collect or ClearCollect on your datasource may not fetch all records depending on your List size. The amount of records saved in memory is dependent on your Data Row Limit (Default 500, max 2000). In other words, the supplied ClearCollect code can only fetch up to 2000 rows.

     

    As long as your Data Row Limit (see app settings) is set to 2000 and your List will not exceed this number, you can ignore this warning. 

     

    If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

    Thanks!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 326 Most Valuable Professional

#2
11manish Profile Picture

11manish 168

#3
sannavajjala87 Profile Picture

sannavajjala87 75 Super User 2026 Season 1

Last 30 days Overall leaderboard