cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jaina
Resolver I
Resolver I

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
NiloferA
Responsive Resident
Responsive Resident

Hello @jaina ,

You can use the "Delete a row" action from Excel Online connector. Pass the parameters as

  1. Location - Select the SharePoint Site
  2. Document Library - Select the Library where your Excel File is residing
  3. File - Select the File in question
  4. Table - Select the Table in the File
  5. Key Column - Select the Column from the table based on which you will identify which row to delete
  6. Key Value - Pass the Value which should be matched in the Key Column to locate the row to delete

 

NiloferA_0-1620725778387.png

Hope this helps!

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

View solution in original post

1 REPLY 1
NiloferA
Responsive Resident
Responsive Resident

Hello @jaina ,

You can use the "Delete a row" action from Excel Online connector. Pass the parameters as

  1. Location - Select the SharePoint Site
  2. Document Library - Select the Library where your Excel File is residing
  3. File - Select the File in question
  4. Table - Select the Table in the File
  5. Key Column - Select the Column from the table based on which you will identify which row to delete
  6. Key Value - Pass the Value which should be matched in the Key Column to locate the row to delete

 

NiloferA_0-1620725778387.png

Hope this helps!

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

View solution in original post

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Kudoed Authors
Users online (3,349)