[Get items] action problem

(1) Share

Report

Posted on by KS-29050310-0

106

Hello everyone,
Could someone please help me with the question below?

Question:
In the [Get items] action in my power automate flow. I set the [Top Count] parameter to 1. I would like to know how many rows the [Get items] action in my flow can retrieve from a SharePoint list. In the future, there will be more than 9000 rows in the SharePoint list, so I am concerned whether this will exceed any limits for the [Get items] action.

Since I have set the [Top Count] parameter to 1, it seems that only one row is returned from the SharePoint list each time. Does this mean that I will not exceed the 5,000 item limit? Is my understanding correct?

Background:
I am using Power Automate to transfer project data from Excel to a SharePoint list. In my flow, I use the [Condition] action and the [Get items] action (for the SharePoint list) to check which project data has already been transferred and which data is new.

I have heard that the [Get items] action for SharePoint lists has a limit. I am worried that my flow might exceed this limit. I have heard the limit is 5000 rows. Does anyone have experience with this, or any advice about handling large lists in Power Automate?

Thank you in advance for your help!

Also, sorry for the Japanese in the capture. I have provided the English names of the actions below for your reference. You can compare these names with the screenshots I will post. I have included the Japanese translations in parentheses right after the English action names.
When a file is created or modified (properties only)（ファイルが作成または変更されたとき (プロパティのみ)）

→get a row（実績月の取得）→initialize a variable （変数を初期化する）→list rows present in a table（表内に存在する行を一覧表示）→for each→　get items（複数の項目の取得）→control （条件）

∟　true → [create item]（項目の作成）

∟　false →for each → [update item]（項目の更新）

Here is the expressions in actions↓

trigger : When a file is created or modified (properties only) →I chose a file in a sharepoint doc library

get a row: Key Column→No. Key value →1　

list rows present in a table（get the data from excel）: 　table→table2 Filter Query → project code ne ''

datetime format→ ISO 8601

for getting excel data more than 256 rows, I have turned the Pagination on and set the threshold to 5000

for each : outputs('list rows present in a table')?['body/value']

get items（get the data from sharepoint）: filter query → Title eq 'items('Apply_to_each')?['オーダー番号_前月締め']'　top count→1 I have turned the Pagination on and set the threshold to 5000

control : condition expression →empty(outputs('get items')?[''body/value']) is equal to true

∟　true → create item

∟　false → update item

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Fredrik_A 3,644 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello,

matthewdevaney has a very good blog post about this which I believe should give you some different solutions:

Get Over 5000 Items From A SharePoint List In Power Automate

If my response solved your issue, please mark it as ✅ Accepted Answer and give it a like.

Was this reply helpful? Yes No
KS-29050310-0 106 on at

Like
a
(0)

Report
Copy link

Link copied!

@StretchFredrik

Thank you for your comment

But first I want to make sure if my flow Have already cleared the upper limit problem.

Because I have set the [top count ] parameter with the number 1. I did some research. It says The number in top count parameter in get items action means the number of rows you take from the SharePoint list for a time. So does it mean every time I only take one row from the SharePoint list. Which means I have already cleared the upper limit problem?

Was this reply helpful? Yes No
Suggested answer

Fredrik_A 3,644 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello,

Hmm tricky question that i don't know the answer to, but based on my experience id say that if you have 30 000 items, and SharePoint only gets the top 10 000, and the item you are looking for is outside of those 10 000, it will not be found even with max count returned set to 1.

After a search i found this:

However, this one item is still selected from within the first 10,000 items that SharePoint returns.
If the item you're trying to get is item #10,001 or beyond, it will not be retrieved — even with Top Count = 1.

If my response solved your issue, please mark it as ✅ Accepted Answer and give it a like.

Was this reply helpful? Yes No
KS-29050310-0 106 on at

Like
a
(0)

Report
Copy link

Link copied!

@StretchFredrik

Thank you Very much for your comment
I would like to wait for more answers.

Was this reply helpful? Yes No