Delete row from excel table using power automate

Like (3) Share

Report

Posted on 11 Apr 2025 20:10:32 by CM-11041447-0

Hello,

I have a flow that performs the following:

User inputs via MS Forms
Forms feeds the data into Power Automate
Data is added into a new row within an excel table by Power Automate
Then other stuff is performed by Power Automate

Once all of Power Automate tasks are performed, i'd like to have the row created in the initial table in excel to be deleted (which should always be row 2), but i'm stumped on how to achieve this. Can anyone help by chance?

Categories:

General Questions

All responses (3)

Answers (2)

Verified answer

stampcoin 761 on 12 Apr 2025 at 10:02:32

Like (0)

Report
Delete row from excel table using power automate

Hi @CM-11041447-0,

Not sure if you are stuck on the last step or not. I assume you are struggling on your last step...

According the info you provided, you have an Excel file , within it you defined a table for temporary saving data from Form.

To delete the row , I suggest two option:

Pass the form response id ( or other field can make the form record unique) to the deletion action, then use Delete a row in the action.

If you have quite many action within the flow, Use Get that row as the action,make sure the row is there. then delete it. to make sure the row is there.

see my screen shot of the deletion.

if you need more help, please feel free.
ronaldwalcott 3,569 on 11 Apr 2025 at 21:57:15

Like (0)

Report

Delete row from excel table using power automate

Just a comment.

You should rethink your design if you are using a specific row in an Excel spreadsheet as some type of temporary data storage location.
Verified answer

Michael E. Gernaey 41,254 Super User 2025 Season 1 on 11 Apr 2025 at 21:48:16

Like (0)

Report

Delete row from excel table using power automate

Hi @CM-11041447-0

So here are the steps, but also a recommended step

Since you just added a row, the cache may not be updated yet in the file.

Step 1: Create your row as you did

2. Add a Delay action first, to pause between 3-10 minutes, so the file updates and will unlock for the delete

Use wait conditions to delay flows - Power Automate | Microsoft Learn

3. Do a Delete Row

Since the Add a row has the Key you need to find the row, you don't need to use List Items etc, just grab it like I am. in my example

If this helps you please Mark as such and Maybe a like :)