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.
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:
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.
User | Count |
---|---|
61 | |
50 | |
47 | |
27 | |
17 |
User | Count |
---|---|
26 | |
26 | |
21 | |
20 | |
20 |