Get Items from Large SharePoint online List

(0) Share

Report

Posted on by Mattw112b

1,088

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

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Mattw112b 1,088 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
chevic0z 7 on at

Like (1)

Report
Copy link

Link copied!

Mattw112IG Can you tell me how you did it please

Was this reply helpful? Yes No