You’re offline. This is a read only version of the page.
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.
@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.
@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.
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
@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.
Share
Report
66
All responses (
Answers (