Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Collection and Sharepoint List show different data in datatable after clearcollect


I have a Powerapp with a data table but noticed that some data was missing. The data table uses a collection as the source (Item 1 in the image). However when I refreshed the collection using the "ClearCollect" function (ClearCollect(intakeCollection,'Intake to Savings'), some data in the collection disappears (Item 2 in the image - Notice how ID 5093 is missing). The data in the collection is refreshed using the data from a SharePoint list. Any help would be greatly appreciated.




Super User
Super User


You might need to REFRESH the datasource immediately before the ClearCollect.

Refresh('Intake to Savings');
ClearCollect(intakeCollection,'Intake to Savings')


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

@mdevaney  I tried the refresh before the clearcollect with no success. I have a feeling that the SharePoint list data is cached and when the Collection gets refreshed its getting refreshed with the outdated/cached SharePoint list.

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,024)