Power Platform Community Forum Thread Details

Hello All,

I'm currently trying to collect a list that has a bit over 2000 entries to a collection, to then use this collection as the Items in a combobox. I've tried a number of solutions but it all comes down to the fact that it does not filter past the 2000 elements. Please note that the IDs on my list are past 2700, so it's not a matter of it filtering evenly. Below a thousand there's some and below 2000 others and the rest should be filled with the ones above, but it just brings exactly 2000 elements. Here's the code:

ClearCollect(colMasterList; [0; 1000; 2000; 3000; 4000; 5000; 6000; 7000; 8000; 9000]);;

Clear(CodigosYNombres);;
ForAll(colMasterList;
	Collect(
 CodigosYNombres;
 Filter('Relacion Codigos y Nombres'; (ID >= Value) && (ID < Value + 1000))
	)
)

I don't anticipate it ever reaching around 6000 elements so I'm not calculating intervals based on the last ID, I just want to chunk into a thousand and collect like that. Should this not work?

Note: In spanish we use ; as you do , in english, and ;; as ;. This is not the error.

Categories:

Building Power Apps