Automated Flow SharePoint to Excel only moving 100 items

[S_D_Andrews]

Morning everyone,

I'm having some problems with a workflow and am hoping that the community can share some wisdom on. I have a SharePoint list that currently has approx 1500 items.  This list is one I want to have as few items in it as possible.  One field in this list is a Yes/No question that indicates when an item is ready to be archived to a spreadsheet.   

I have created a Flow that I plan to run (via scheduler) once per evening.  It should poll all items within the list and when the Yes/No is set to Yes, I'll have it copy the item into Excel and delete the original list item.  However in my testing, I'm only moving 100 items at a time.  To test this, I've created a view that shows all items I'm ready to archive and there are 930.

I've checked out the Excel Online (Business) literature and it suggests that I've hit the throttling limit in some fashion.   Whilst I could just let the workflow run nine times moving 100 items per execution I feel there's probably a more elegant design that I'm not seeing.  

Any tips appreciated.  I can post an image of the workflow if that would be useful.

[v-litu-msft · Accepted solution]

Hi @S_D_Andrews,

That is the limitation of the Get items, please go to Settings to turn on the Pagination feature, then set the Threshold to maximum 5000:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[S_D_Andrews]

This did the trick.  Many thanks.