Answered

Data Retrieval Error Using Collection

(0) Share

Report

Posted on by Phineas

5,325 Super User 2025 Season 2

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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

Michael E. Gernaey 53,479 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (0)

Report

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!

Was this reply helpful? Yes No