Help on ClearCollect

[echodapogi]

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

[echodapogi]

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?

[echodapogi]

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

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

[WarrenBelz]

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