I copied the code directly.
I am not getting any data in the Loopcount collection. And I can still only see the first entered list items.
😞
Um, would you mind sharing a screenshot?
Thanks,
I saved and published and it worked for all list items.
I am not totally convinced it will work when the list goes past 2000 items.
Is there a way I can test with only 800 items, using the setting of pulling 500.
Something like this?
ClearCollect(LoopCount,FirstN([0,500, 1000, 1500, 2000],RoundUp(First(Sort('Active Field Leadership',ID,Descending)).ID/500,0))); Clear(ListItems); ForAll(LoopCount,Collect(ListItems,Filter('Active Field Leadership','Performed By'.Email=User().Email && ID > Value)))
Hey @NicolaNeedsHelp
In that case, set your Data Row Limit for Delegation to 500, so it will fetch only first 500 recods at a time.
expression:
ClearCollect(LoopCount,FirstN([0,500, 1000, 1500, 2000],RoundUp(First(Sort('Active Field Leadership',ID,Descending)).ID/500,0)));
Clear(ListItems);
ForAll(LoopCount,Collect(ListItems,Filter('Active Field Leadership','Performed By'.Email=User().Email && ID > Value)))
else,
If you don't want to modify the data delegation limit, please use below expression:
ClearCollect(LoopCount,FirstN([0,500, 1000, 1500, 2000],RoundUp(First(Sort('Active Field Leadership',ID,Descending)).ID/500,0))); Clear(ListItems); ForAll(LoopCount,Collect(ListItems,Filter('Active Field Leadership','Performed By'.Email=User().Email && ID > Value && ID <= Value + 500)))
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Firstly, thank you so much for all your help so far.
I have attached some screen shots.
View 1 and Code 1 set with 500 limit. View 2 and Code 2 with 2000 limit.
Just trying to make sure I dont have to revisit it all when the list goes beyond 2000 entries.
Code 2
ClearCollect(LoopCount,FirstN([0,2000,4000,6000,8000,10000],RoundUp(First(Sort('Active Field Leadership',ID,Descending)).ID/2000,0)));
Clear(ListItems);
ForAll(LoopCount,Collect(ListItems,Filter('Active Field Leadership','Performed By'.Email=User().Email && ID > Value)))
Hey @NicolaNeedsHelp
Code 1 did not pull more than 500 records.
Did I do something wrong?
Hey @NicolaNeedsHelp
No records, just a heading
Hey @NicolaNeedsHelp