ClearCollect is not working in App OnStart

[JB0007]

Hi PowerApps community,

I want to collect (ClearCollect) data from my SharePoint list into a collection. My SharePoint has maximum 50 records in the SharePoint list. I have inserted the following formula in the OnStart property of my App:

ClearCollect( mySharePoint, Status = "Active").

But when I start the app the collection is blank. 

Does anyone has a workaround for this?

Any help will be much appreciated.

[CNT]

@JB0007 The formula will be like this,

ClearCollect(myCollection, Filter(mySharePoint, Status = "Active"))

[Pstork1 · Accepted solution]

• First, is Status a choice field?  If it is then your filter should be Status.value="Active".
• Second, you need to specify the SharePoint list you want to put in the collection
• Third, if you want to filter it you need something like filter(sharepointlist,Status.value="Active")
• Fourth, you need to make sure the Enable OnStart property is turned on in the settings.
• Fifth, you need to turn off the Delayed Load feature in Preview Features.