Unanswered

Get more than 5000 items from excel and delete the rows

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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!

Categories:

Process mining

I have the same question (0)

All responses (4)

Answers (0)

Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Jcook is there any blog that i can follow for the workaround?

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No