cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mattw112IG
Impactful Individual
Impactful Individual

Get Items from Large SharePoint online List

I have a large SP online List with 60,000 items.

 

MS removed the indexing limits and I have added an indexed column "Modified".

 

That all seems fine.

 

I have a Flow I create to Get Items and then based on conditions I create a report.

 

But I can't get through the Get Items.  Keeps saying "The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator."

 

Since this is SP Online I don't know where I would go to see if there's some hard limit set or not.  I've found instructions with older versions/On premise for Central Admin Site being able to set this to what you want.  Not sure I fi can online?

 

Or even if that is the problem.  Maybe Flow is just hard coded not to run if over 20K or 5K??

 

Does anyone know?

 

Thanks,

Terry

1 ACCEPTED SOLUTION

Accepted Solutions
PrasadAthalye
Community Champion
Community Champion

@Mattw112IG - Are you trying to query more than 5000 items in 1 call? Can you create a view which returns less than or equal to 5000 items and use that in Get Items?

 

Other option is to use REST API and run a loop to grab the items with top 5000 clause added. store last ID value and add 5000 to it and query again.

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

3 REPLIES 3
PrasadAthalye
Community Champion
Community Champion

@Mattw112IG - Are you trying to query more than 5000 items in 1 call? Can you create a view which returns less than or equal to 5000 items and use that in Get Items?

 

Other option is to use REST API and run a loop to grab the items with top 5000 clause added. store last ID value and add 5000 to it and query again.

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

Thanks I ended up doing similar.  Not using REST API just regular action.  Get ID 1-4999, Get ID 5000-9999, get ID 10000-14999, get...

 

Terry

chevic0z
Frequent Visitor

Mattw112IG Can you tell me how you did it please

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (5,208)