Power Automate

Run Script and delete a Row to Excel Table in the same flow with large datasets

(1) Share

Report

Posted on by DineshK_

205

Hi Experts,

I have a sharepoint excel file which has count of 333k rows.

I am trying to remove the rows with the filter below :

Email : contains 'noemail' , Country : Not GERMANY , Progress : Not Completed

but the "List rows in a table" action has a threshold of 100k only.

in that case i am planning to run office scripts and then delete the satisfied rows.

Can you please guide me how to prepare the flow after run scripts ?

Below is the original result for script from excel .. we have to remove these rows from the file.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Here's an easy path to get this done. If this is something you need to do occasionally, create a new worksheet in the same workbook that does the filter against your 300K rows and then in your list rows present in a table, point to the filtered table.

------------------------------------------------

⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
DineshK_ 205 on at

Like (1)

Report

@trice602 Yes but that will be manual task for them , earlier they have done all these tasks manually every month.

Now they came to us to automate these filters and delete the rows actions from PA jobs.

Was this reply helpful? Yes No
trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

Understood. If you are using Power Query, this table can refresh so there's it's only a manual step to setup the query one time. You could also do the exact same thing with Office Scripts.

------------------------------------------------

⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

Hey there!

I am following up on this post run script and delete a row to excel table in the same flow with large datasets in this category building flows from 12/12/2024. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 3 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No