You’re offline. This is a read only version of the page.
Hi All,
i am looking to build a flow that gets more than 5000 items from excel and then deletes all the rows. Currently there is a limitation on 5000 items as maximum number of items for retrival.
Is there a possible solution that can be used to retrieve more than 5000 items and then delete all of those items.
I have a static excel file that is placed on SharePoint document library, and the data is formatted into a table.
Hope PowerAutomate users can help me out.
Cheers!
Thanks in advance!
@Jcook is there not any workaround that lets us delete all the items from the excel file be it 5000 or greater than 5000 items?
Hi @Anonymous
What is your trigger?
My proposed workaround is not perfect. Basically lets say you have 8000 rows you want to delete.
Flow runs 1 time and deletes 5000,
Flow runs second time and deletes 3000 rows.
@Jcook is there any blog that i can follow for the workaround?
Hello @Anonymous
This is most likely a limitation on your license. Check this documentation here:
Limits and configuration - Power Automate | Microsoft Docs
The Apply to each limit is 5000 for licenses:
- Free
- Microsoft 365 plans
- Power Apps Plan 1, Per App plans
- Power Automate Plan 1
- All license trials
You could use a workaround where the Flow runs multiple times until excel file is empty.
Share
Report
All responses (
Answers (
7,770