How to Query Filter Large Lists

[JBSF]

Hello,

I have a list with 18,000 items, and am trying to write a flow to pull information from the list.  I am using the 'Get items' action and the 'Filter Query' line, and I currently have the advanced options of the 'Get items' action set up as the following:

Site Address: Sharepoint Site

List Name: Large List

Filter Query: startswith(Column, 'Column Filter')

Order By:

Top Count: 18000

Limit Columns by View: 

Unfortunately, while I should receive 14 results from searching all 18,000 items, I am only receiving 1.  I believe this is because the 'Get items' action is still only searching the first few items.  What can I do so that the flow finds all the relevant items from the large list?  Thank you for your help.

[v-yuazh-msft]

Hi @JBSF ,

You couldn't set the Top Count to18000 since you cannot retrieve more than 5000 items, there is a 5K items limitation on Get items action of sharepoint,you could refer to link below for referance:

https://powerusers.microsoft.com/t5/General-Flow-Discussion/What-is-the-maximum-limit-for-Get-Items-...

And I have made a test on my side, the startswith(Column, 'Column Filter') would works well to filter the items:

Best regards,

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