Not able get some records in Collection

Like (0) Share

Report

Posted on 3 Apr 2025 11:08:35 by SR-02111122-0

Hi community,

I am facing a problem related to collection, From SharePoint list I am storing data in my collection but issue is the records which are present in SharePoint list i am able get them in collection but only 4 or 5 of them is not displaying in collection. I tried refreshing collection or data source but still only those 4 or 5 of records are not visible. Anyone know what might be the issue?

Categories:

Power Apps component framework

Power Platform Build Tools

Application Lifecycle Management (ALM)

All responses (1)

Answers (1)

Verified answer

SwatiSTW 532 Super User 2025 Season 1 on 03 Apr 2025 at 11:40:30

Like (0)

Report

Not able get some records in Collection

Some records from your SharePoint list are not showing in the collection. This usually happens because of data limits, filters, or issues with the data type or user access.

1. Increase the data row limit in app settings to 2000
go to Settings > Advanced settings > set Data row limit for non-delegable queries to 2000

2. Use delegable filters to make sure all records load
example:
ClearCollect(colData, Filter(MyList, Status.Value = "Active"))
avoid using functions like Left, Mid, SortByColumns on large lists unless they are delegable

3. Check if your filter is excluding data
test without filter to see if records appear
ClearCollect(colTest, MyList)

4. If your SharePoint list uses Choice, Person or Lookup fields, access them correctly
example for Choice: Status.Value
example for Person: Author.DisplayName
example for Lookup: Department.Title

5. Check if some records are hidden due to SharePoint permissions
go to the SharePoint list and make sure all records are visible to you

6. Check if any SharePoint items have missing required data or errors

7. Use Errors function to detect if any record failed to load
ClearCollect(colTest, MyList); ClearCollect(colErrors, Errors(MyList))