Delete row from excel table using power automate

(3) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Michael E. Gernaey 53,362 Super User 2025 Season 2 on at

Like (0)

Report

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 :)

Was this reply helpful? Yes No
ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report
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.

Was this reply helpful? Yes No