I am receiving this new error that I didn't get last week.
Unable to process template language expressions for action 'Apply_to_each_3' at line '0' and column '0': 'The number of for each items limit exceeded for action 'Apply_to_each_3': maximum '5000' and actual '5120'.'.
I have set the Pagination on the Excel List Rows Present in Table and SharePoint Get Items to 6000. There are only 445 rows in my Excel spreadsheet so I'm not sure where 5120 is coming from. Any advice on what the issue could be?
Solved! Go to Solution.
did you already found a way to update your 15k entries and bypass the limit of 5000 items?
I have a similar case where I need a daily update on a excel file which I convert to an csv.
The excel contains a script, which I can trigger via the flow.
I am just struggling with the 5.000 item limit
Hi @chris-l , nothing. Poor documentation and lack of support.
BTW. Did you tried implementing before a OData filter? Do you need to call all of the items at once? Maybe if you reduce the size of your query you can get the results?
Thanks for quick response!
Unfortunately I need every of the rows, so no filtering possible.
I will continue trying to seperate the rows in 8 parts and combine them in the end. Maybe this will work somehow.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.