I just noticed that the ListItems collection includes some duplicates that need to be removed. How can I correct this? Here is the code I modified based on our previous discussion:
ClearCollect(LoopCount,FirstN([0, 2000, 4000, 6000, 8000, 10000, 12000],RoundUp(First(Sort('Item Tracker',ID,Descending)).ID/2000,0)));
Clear(ListItems);
ForAll(LoopCount,Collect(ListItems,Filter('Item Tracker',ID > Value)));
@pwrappr01 Do you have duplicates in your SP list or is it getting collected inside the collection?
@pwrappr01 wrote:
I just noticed that the ListItems collection includes some duplicates that need to be removed. How can I correct this? Here is the code I modified based on our previous discussion:
ClearCollect(LoopCount,FirstN([0, 2000, 4000, 6000, 8000, 10000, 12000],RoundUp(First(Sort('Item Tracker',ID,Descending)).ID/2000,0)));
Clear(ListItems);
ForAll(LoopCount,Collect(ListItems,Filter('Item Tracker',ID > Value)));
Thanks for your solution.
For SharePoint this seems to be working, but it isn't for Excel.
User | Count |
---|---|
140 | |
137 | |
77 | |
76 | |
69 |
User | Count |
---|---|
224 | |
185 | |
68 | |
64 | |
57 |