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

Help on ClearCollect

Hello there, 


I have an SP list of 4952 records (xlsPullbackTablePlanningList) and i am trying to use ClearCollect(tempBatchID,xlsPullbackTablePlanningList) to create a tempBatchID collection but the returned data is only 16 records..


Any thoughts why? 


the reason why i needed is i am trying to avoid delegation issues on my dropdown box by using the 

Distinct(Filter(tempBatchID, Status = "Pending"), BatchName).  but i dont understand why my collection is only 16 records. 


Please help. thanks in advance



if i am going to create a new numeric field of vModID.. what value it needs to start.. from 1 to the end of the records? lets say 5k?

WarrrenBelz, Good News.!!! I made it.. yahoo!!

my colMyCol value now is 4682. THANK YOU THANK YOU THANK YOU!!!



@echodapogi ,

After all of that, you marked one of your posts as the solution. Can you please mark the one of mine that helped you the most.

Helpful resources

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users


We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (22,579)