How to delete row in excel online based on cell value using Power Automate

(0) Share

Report

Posted on by jaina

517

Hi,

I have an Excel file which resides to our SharePoint site.

I already has a flow wherein if the Status field has been changed to Completed, the Status field in SharePoint List will be updated. Now, I want to delete row right after I update the item in SharePoint List.

Basically, delete a row in excel table when Status is equal to Completed.. How do I do that? Kindly help? Thanks

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

NiloferA on at

Like (0)

Report
Hello @jaina ,
You can use the "Delete a row" action from Excel Online connector. Pass the parameters as
Location - Select the SharePoint Site
Document Library - Select the Library where your Excel File is residing
File - Select the File in question
Table - Select the Table in the File
Key Column - Select the Column from the table based on which you will identify which row to delete
Key Value - Pass the Value which should be matched in the Key Column to locate the row to delete

Hope this helps!
Please give a Kudo or mark this Reply as Solution if you found it helpful.

Was this reply helpful? Yes No
bkumar 46 on at

Like (0)

Report

What to do if my delete condition is based on two columns

Was this reply helpful? Yes No