cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pwrappr01
Level: Powered On

Re: How can I efficiently load 10,000 items from a SharePoint List into a Collection?

@yashag2255,

 

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)));

Highlighted
Dual Super User
Dual Super User

Re: How can I efficiently load 10,000 items from a SharePoint List into a Collection?

@pwrappr01  Do you have duplicates in your SP list or is it getting collected inside the collection?

pwrappr01
Level: Powered On

Re: How can I efficiently load 10,000 items from a SharePoint List into a Collection?

@yashag2255,

 

I just verified my SP List to ensure there were no duplicates there.

Rens_
Level: Powered On

Re: How can I efficiently load 10,000 items from a SharePoint List into a Collection?


@pwrappr01 wrote:

@yashag2255,

 

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.

 

 

Karteek
Level: Powered On

Re: How can I efficiently load 10,000 items from a SharePoint List into a Collection?

is it still working? ID is giving delegation warning now and count limited to 2000.

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,741)