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.
hi @Anonymous please see this example I made it.
My excel:
Empty compares if I have values in list rows.
empty(body('List_rows_present_in_a_table')?['value'])
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2