web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Delete Rows w/ Excel (...
Power Automate
Unanswered

Delete Rows w/ Excel (Business) connector

(0) ShareShare
ReportReport
Posted on by

Hello there, 

I am trying to get a list of rows deleted in a excel table every day. But so far, I am unable to get my filtered lines deleted. I am certainly do not get KeyColum and KeyValue right in my workflow. 

 

If anyone who got it working and can share its experience?

 

Thanks in advance!

 

téléchargement (2).jpgtéléchargement (3).jpg

 

Categories:
I have the same question (0)
  • Verified answer
    v-yamao-msft Profile Picture
    on at
    Re: Delete Rows w/ Excel (Business) connector

    Hi @Anonymous,

     

    I am afraid that you have to make some changes on the action Delete a row.

    In the action Delete a row, we are asked to select a column from the drop-down and enter the Key value.

    I have made a test likes below for your reference.

    In the action Delete a row, select the column from the dropdown, and enter the following code in the Key value field:

    item()?['name']

     

    Please check the following screenshots:

    1.PNG2.PNG

    Please take a try with it and feel free post back if you have any problem.

     

    Best regards,

    Mabel

  • Community Power Platform Member Profile Picture
    on at
    Re: Delete Rows w/ Excel (Business) connector

    Thank you Mabel, workd perfectly!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard