Answered

Iterate items through SharePoint list

(0) Share

Report

Posted on by hexarthrius

I have a column in a SharePoint list which has a specified date (let's call this Effective Date), and I want Power Automate to send me a notification if the Effective Date is equals the date today.

The logic to do the above is simple enough, but the problem is, I have to loop through 1k+ list items if I want to check each and every one of the items to see if I need to send an email today via Power Automate. Is there a way to loop through the list? Right now based on tests, we can only process 100.

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

RobElliott 10,489 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@hexarthrius by default the Get items will only bring back 100 items, but you can change this by clicking on the 3 dots at the top right of the action and select Settings. Then turn on the Pagination toggle and set a threshold value that is more than the number of items in your list.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
vikulkar Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @hexarthrius ,

the issue with getItems getting only 100 records is because the Pagination is currently turned off for the action.

Please follow the steps that @RobElliott provided and you should be able to get all the items from the list.

Thanks and Regards

Was this reply helpful? Yes No
hexarthrius 66 on at

Like (0)

Report
Copy link

Link copied!

@RobElliott, thanks for the recommendation. This is exactly what I needed for now, but hope you can provide info on what will I use in case the list grows to >5000? As I understood in the docs, the limits on the ForEach is also 5,000.

Was this reply helpful? Yes No
vikulkar Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@hexarthrius : One workaround you can consider that many users go for is having a new list with a new flow once such limits are reached.

This way the flow performance is also not degraded because it has to go through single list with >5000 items.

Was this reply helpful? Yes No