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

Excel Table: Delete a row: "No row was found with Id (xxx) issue"

Like (0) ShareShare
ReportReport
Posted on 9 Mar 2020 13:37:42 by

This should be fairly simple. I just want to remove all existing rows from a table within an Excel spreadsheet.

 

If it's relevant, the spreadsheet sits in a Sharepoint site. No permission issues etc; I have full access to this site and table.

 

The flow is fairly simple: 

Manual trigger => List rows present in table => Delete a row. For testing purposes, there are currently only 2 rows in the table. 

 

The key column is 'ProjectCode'. For the 2 rows, the ProjectCode values are 'xyz' and 'abc' respectively. Changing these values does not solve the problem. 

 

Every time I try to run the flow, I get the error: "No row was found with Id 'xxx'" ('xxx' is whatever value that happens to be in the keyColumn for the first row).

 

(I've actually tried following this workaround for the issue, but I'm relatively new to Flow and couldn't get past the 'Set row count to the number of rows in the excel sheet' step, since I couldn't assign the length() function to the number of rows-perhaps this would be a workaround if someone could explain how to do this, since Flow doesn't seem to have any countRows() function??)

 

This is very frustrating. It seems like a very basic task...what obvious thing am I missing here? 

 

Thanks. 

 

 

  • Verified answer
    ChristianAbata Profile Picture
    8,949 Most Valuable Professional on 09 Mar 2020 at 14:08:09
    Re: Excel Table: Delete a row: "No row was found with Id (xxx) issue"

    hi @Anonymous  please see this example I made it.

     

    My excel:

    rows.PNGrows1.PNGrows2.PNG

     

    Empty compares if I have values in list rows.

    empty(body('List_rows_present_in_a_table')?['value'])

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete