cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Super User
Super User

@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

2 REPLIES 2
Super User
Super User

@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

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

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (42,596)